2 Replies Latest reply on Aug 9, 2009 5:56 PM by leesan

    Problem with database relationship



      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?