+12I have a table based on 3 digit zip that has the user listed for each 3 digit zip. On the main table/form, when a user clicks a checkbox, I would like the user field to update to the correct user based on the 3 digit zip code that is on the record. Can you advise how I would do that?
Best answer by ChayceDuncan
Do you have a relationship between the Zip Table and your main table? If not, you will want to establish a relationship between those two, with Zips being the parent table having many records in your main table.
In that relationship - you would add a lookup of the user assigned to that Zip. In your main table form - you would then have a form rule that copies that value of that lookup field into the user field on your main table when the box is checked.
+9Do you have a relationship between the Zip Table and your main table? If not, you will want to establish a relationship between those two, with Zips being the parent table having many records in your main table.
In that relationship - you would add a lookup of the user assigned to that Zip. In your main table form - you would then have a form rule that copies that value of that lookup field into the user field on your main table when the box is checked.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
