AnsweredAssumed Answered

Bring over field values from DropDown Value

Question asked by bokenrosie on Nov 9, 2017
Latest reply on Nov 9, 2017 by philmodjunk

I have a problem where I am not getting other field information when I choose a drop down list.


For example client name is a particular office - in this case Zions Public Finance.  I have a table for that office called clients and in that office there are contacts who have name, phone and email.


When I enter a new deal name ie) Board of Education.... in this screen shot and choose Zions and then Jonathan I want his contact name and phone to populate.  Right now it is creating another record in the Contacts and Clients tables.


I am using value list for Client Name and Contact Name on the Layout that point to the tables respectively.


The related fields are like this:



The layout looks like this:


Thanks for any guidance.