i did a search, but couldn’t find an answer specific to my situation. i have a table with a record for each MAC address for each client. each client has 3 MAC addresses, so there are three records for each client. i would like to create a mail merge using this data, but the mail merge needs one record per client with a field for each MAC address. for example:
Table 1
CLIENT MAC IP PHONE
Dave 001A Ephone1
Dave 001B Ephone2
Dave 001C Ephone3
Table 2
CLIENT EPHONE1 EPHONE2 EPHONE3
Dave 001A 001B 001C
i would like for Table 2’s EPHONE fields to automatically change/update based on the values in Table 1’s MAC fields and using the IP Phone criteria. i tried changing the fields in Table 2 into Lookup fields, but it does not automatically change the values.
fwiw, i’m not an Access expert nor am i an expert at SQL, so please keep that in mind when responding…lol
THANKS!