AnsweredAssumed Answered

Auto-Populating Field by Referencing a Calculated Result

Question asked by ChadBarnard on Aug 14, 2014
Latest reply on Aug 14, 2014 by ChadBarnard

Title

Auto-Populating Field by Referencing a Calculated Result

Post

     Here's what I'm trying to do:

     The picture is of the Orders Table.  I'm trying to get the County Name field to auto-populate based on the County field above.  The problem that I'm having is that the County field is auto-populated by a calculation that's triggered when the city is entered.

     I have the Permit City Contacts on one table that auto-populate the left side (this is what PhilModJunk helped me with yesterday), and I have a separate table for the Permit County Contacts.  The Permit City Contacts Table is related to the Orders Table by state and city, and the Permit County Contacts Table is related to the Orders Table by county. 

     I know how to do it if the County field was entered text, but I having trouble making it work when it's referenced text.

County.PNG

Outcomes