AnsweredAssumed Answered

One company multiple Person in charge with different address

Question asked by kentanderson on Feb 12, 2014
Latest reply on Feb 13, 2014 by philmodjunk

Title

One company multiple Person in charge with different address

Post

     Im finally getting the hang of FM pro, Now here is what i need help with.  I have a Clients table, with Client Id, Company Name, Person in charge, address, city, state, zip.  I also have a table called Jobs, with Client ID.  I have a one to may relationship between the client Id's the Clients table is the parent.  Now for the trouble, I have a form with a drop down list that I want to display Person In charge, and Company.  I want this so that when i select this it will fill in the other info automatically, Address , city, etc.  Currently I have this set up where i see client id, and company.  but sense the drop down can not list three items, I have no Idea which person in charge i am selection.  This is a problem because Most the companies we work with have offices all over the country, with different person in charge and different address.  Any advice welcomed.  Thank you in advance.

Outcomes