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.