Forum Discussion

CarolMcconnell's avatar
CarolMcconnell
Qrew Captain
2 years ago

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 ba...
  • ChayceDuncan's avatar
    2 years ago

    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
    ------------------------------