One company multiple Person in charge with different address
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.