AnsweredAssumed Answered

Problem with database relationship

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

Title

Problem with database relationship

Post

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?

Outcomes