Hi,
I'm trying to design a payment request form that provides drop down lists of authorised signatories based on the value of the payment. There will be two signatory drop down lists.
The first list will be based on the value of the payment, the 2nd list will be based on the first list.
The authorisation ranges are as follows
0 - 10,000 1 Person from List C
10,000 - 50,000 (Mr A or Mr B + 1 person from List C) or 1 Person from List B
50,000 - 250,000 (Two from List B or 1 from List A)
250,000 - 500,000 Mr D and either (Mr E or Mr F or I list A)
500,000 + Mr D or Mr E or Mr F + I List A
List C - Mr A, Mr B, Miss C, Mr AB
List B - Mr D, Mr E, Mr F, Mr G, Mr H, Mr I
List A - Mr Z, Mr X, Mr Y, Mr T
so for example if I was requesting a payment of 45,000 then
List 1 = Mr A, Mr B, Miss C, Mr AB, Mr D, Mr E, Mr F, Mr G, Mr H, Mr I
List 2 = Mr B (if Mr A was selected List 1), Miss C, Mr AB OR Mr A (if Mr B was select in List 1), Miss C, Mr AB OR the list would be blank if List 1 selected Mr D, Mr E, Mr F, Mr G, Mr H, Mr I
I presume I will need some sort of indexing and various list combinations but I'm not sure how to string it together. Any help would be appreciated.
I'm trying to design a payment request form that provides drop down lists of authorised signatories based on the value of the payment. There will be two signatory drop down lists.
The first list will be based on the value of the payment, the 2nd list will be based on the first list.
The authorisation ranges are as follows
0 - 10,000 1 Person from List C
10,000 - 50,000 (Mr A or Mr B + 1 person from List C) or 1 Person from List B
50,000 - 250,000 (Two from List B or 1 from List A)
250,000 - 500,000 Mr D and either (Mr E or Mr F or I list A)
500,000 + Mr D or Mr E or Mr F + I List A
List C - Mr A, Mr B, Miss C, Mr AB
List B - Mr D, Mr E, Mr F, Mr G, Mr H, Mr I
List A - Mr Z, Mr X, Mr Y, Mr T
so for example if I was requesting a payment of 45,000 then
List 1 = Mr A, Mr B, Miss C, Mr AB, Mr D, Mr E, Mr F, Mr G, Mr H, Mr I
List 2 = Mr B (if Mr A was selected List 1), Miss C, Mr AB OR Mr A (if Mr B was select in List 1), Miss C, Mr AB OR the list would be blank if List 1 selected Mr D, Mr E, Mr F, Mr G, Mr H, Mr I
I presume I will need some sort of indexing and various list combinations but I'm not sure how to string it together. Any help would be appreciated.