Auto-Populating Field by Referencing a Calculated Result
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.