Hi I'm a newbie at Access and I've come across a problem I can't easily Google the answer to.
I have a table of client data. One field is the Spouse ID, which stores the record ID number of the client who is the spouse of said client. I have a form that I am using to edit the information, and when I update the Spouse ID in that form for one client I would like it to also update the Spouse ID of the client's spouse to the Record ID of the current client, so they always match up with each other. What's the easiest way to do this? VBA? Thanks for any help!