Question

Locked

Update field in one table from a field in another table

By kminatta ·
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!

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums