Hi
I have 3 tables named COMPANY, CONTACTS & JOB. Each has fields as follows;
COMPANY: cmpID,companyName, address
CONTACTS: cntID,contactPerson,companyName(this is a foriegn key refer to COMPANY table)
JOB: job,companyName, contactPerson(this is a foriegn key and refer to CONTACTS table)
Company may have multiple contact person
A job should have a one contact person and one company
My problem is this; I have an form to enter job details. It has a dop down menu to select company neme. after selecting a company from there i wand to load relevent contact people from that company to load into next drop down menu in the forum.
Could some one please help me in this.
Thanks
Hansi