I am trying to use the UPDATE query to go from a many-to-many arrangement to a one-to-many arrangement. My current arrangement relates client to addresses via a relational table. So my contact table has autonumber ContID as key, and my address table has autonumber AddrID as key. the relational table has ContID and AddrID as primary keys. I am having a very difficult time deals with the many-to-many for a data entry, and after some though realize I don't need that arrangement. A client can only have one home mailing address but more than one client could theoretically live in the same house.
So I created a field in the contact table for an Address ID. But I have having trouble setting up the update query such that it puts the AddrID from the relational table in the new contacts table AddrID field where the AddrID and ContactID match in the relational table. Thanks.