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.

Outcomes