BleepingComputer.com: Ms Access 2k3, Relational Databases

I haven't used access since I was in school in like 2001. We learned a little about it. That's all I remember...

I have this database with two tables with the following fields:

ID, LastName, FirstName, Address1, Address2, City, State, Zip... on & on.

The ID field in both tables are autonumber and are primary keys.

Each table is for a seperate church group, but some members belong to both groups; some belong to only one group.

I want a relationship where the records stay in sync if the member is in both groups.

Or if there's a better way alltogether let me know. I"m use to storing info in notepad or on little sheets of paper.

Add another record to the field to represent churchgroup 1, churchgroup 2, or both. You can then use one database for both, and keep the members in both syncronized with one update entry, as I understand your problem.
Cheers,
John