Hi All.
Essentially i want to send a payment to external users to authorise the amount and the rules are based on external user names in 3 tables. Is this possible?
The users will be from 4 companies. The rules are:
1) values up to £25,000 One individual from table C + One individual from table A or B
2) values in excess of £25,000 but less than £100,000 One individual from table C + three other individuals from table A or B (note the individuals can not be from the same company)
3) values in excess of £100,000 One individual from table C + two from table A and 1 from table B or 3 from table A (note the individuals can not be from the same company)
I am really stuck how to to do this and any help would be massively appreciated

Report
All responses (
Answers (