[MS_AccessPros] Many to Many question

 

Hello all,

I am recreating a database that should have had a many to many relationship set up. There are 2 tables one with Management Companies and the other is the Home Owners Associations which are managed by the Management companies. A third table is called Projects where this table is linked to the Home Owners Association table, as there is 1 to many projects.
The issue is that Home Owners Associations are now moving to and between Management companies. I have studied on how to define and set up the many to many relationships but I can not find out how to populate the junction table without manually adding the records.

And how do the history of projects for associations not go away when the associations move to a new Management companies?

So my question is how do I set up this many to many relationships?

Thank You

Jim Wagner

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 3

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___