I have a database that includes two dropdown menu fields. These fields can have multiple selections, but are limited to the list. One field is filled out for each record, but the other field was just added. I have 500 records, and would like to know if I can run a macro to fill in the new field based on the values checked in the first field. For example, if this is the first field:
Product Lines
X Hotel
O Multihousing
O Door Closers
O E-Plex
X Levers and Handles
O Simplex
O Keyscan
O RCI
The macro should see that "Hotel" and "Levers and Handles" are both checked, and check the boxes in the list in field 2 that correspond with those product lines. Is this possible, or will I have to go through and check the boxes for each record myself?