Solved
Autofill user field when a checkbox is checked
I 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?
------------------------------
Carol Mcconnell
------------------------------
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.
------------------------------
Chayce Duncan
------------------------------
