Hello,
I have 2 dropdown fields in a form
a ) company (in its own table)
and
b) contact person. (in its own table, where contact persons are recognized using company ID)
Now what i want to do is when a company is selected ie. in field a) , i want only the contact persons under the company selected to appear in the field b) dropdown.
In the field b), i have edition lookup sql statement as:
SELECT ID, contacts
FROM contacts
ORDER BY contacts
I dont know if i could explain it well but hope its understandable.
any help?
Thanks!