Problem with database relationship
I have 3 tables in FileMaker. They are:
1. Jobs(job_id[PK], description, client_id[FK], pic_id[FK])
2. Clients (client_id[PK], client_name)
3. ClientPIC (pic_id[PK], pic_name, client_id(FK))
Once a job is recorded, job_id is generated (serial) and user must enter description
and select client_id and pic_ic through drop down list.
Drop down list for pic_id suppose to shows a list of person in charge of selected client and not all pic in ClientPIC table.
How do I do that?