Help
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.
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. 
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.
Back to top
