5 Replies Latest reply on Feb 13, 2014 11:30 AM by philmodjunk

    One company multiple Person in charge with different address

    kentanderson

      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.