Yes, you are missing a step.
You will need to set the table which has your ZIP Codes and counties such that the ZIP Code is the key field.
Then you will need to make a relationship where one postal code entry has many transactions. For the reference field on the right side of that relationship you will use your look up field that you show in the picture above which is the ZIP Code.
Then you will be able to look up the county from the ZIP Code table down to your transactions table.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com------------------------------
Original Message:
Sent: 02-26-2020 20:48
From: Benjamin Brooks
Subject: Lookup County with Zip Code
I would like to have a field populate with the county based on the zip code that is entered into the zip code field. I have built a table called counties and this table has the zip and the county in rows. I set up the advanced settings like this:
------------------------------
Benjamin Brooks
------------------------------