I am sure this is a pretty basic question but because I lack of knowledge I want to ask you what I am looking for in technical terms. How do I describe technically correct what I am looking for?
This is what I am looking for:
- I have a “list of zip codes” where each zip code is assigned to a certain value. This value is a tax rate.
- I also have a “database of clients” where there is always a zip code. I want to find out which tax rate applies to them according on the “list of zip codes”.
3.I have a already a field where I link from my “database of clients” to the “list of zip codes”. If I type in manually in each line the zip code it works!
I created a table where I put the list of zip codes and tax values, I linked it from my table where I store my user data and now I can look up manually by typing in the zip code in my user table the tax value from the new table.
But I want that “automatically” so that the zip code from the user table automatically is requested in the other table.
How do I do that?
Thanks in advance!!