Hi All,
I have 2 tables: Employee Table and Vendor Table. Employee table consists of Employee Name field and Vendor Table consists of Vendor Name field.
There is Payment table consists of Pay to field.
The idea is: Pay to field is text multiple-choice field, containing list of Employee Name field and Vendor Name field. I also can create new choice with this field, if "Pay to" person or vendor not listed there, but I don't want to add this newly created choice to employee name field or vendor name field.
Is there any solution to achieve this rather than manually input again employee name list and vendor name list as multiple-choice list of Pay to field?
Many thanks
------------------------------
Syaeful Bahri
------------------------------