Reciept - Payment Lines
I have a table called Dimension Values which looks like this
DimensionCode Code Name
Donors 100 Germany
Donors 200 Canada
Donors 300 Others
Prog 1000 x
Prog 2000 y
Prog 3000 z
I also have a List form called Dimension Value which has details of the above table.
Now i have another Form and Table called Receipt Form and Receipt Table respectively. This Receipt table has these 2 fields among others Donor and Prog. On the Receipt form i want when i lookup field Donor, The dimension value Form should only present data wheredimensioncose=donor. Likewise when i look up prog field, dimension value Form should only present data wheredimensioncose=prog.
Thanx