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.