AnsweredAssumed Answered

Problem with database relationship

Question asked by leesan on Aug 7, 2009
Latest reply on Aug 9, 2009 by leesan


Problem with database relationship


Hi guys.

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?