Forum Discussion
ChrisChris
7 years agoQrew Assistant Captain
To form a many to many between two tables, you need a third Details table:
Provider >> has many >> Details Records.
Address >> has many >> Details Records.
The Details table collects all the other information like terms and maintenance and contracts, etc. This arrangement prevents redundancy among Provider and Address, and gives you the many-to-many relationship between Provider and Address you are seeking.
The two parent records are pulled in to the Details Record via drop down selection lists or Record Pickers.
Provider >> has many >> Details Records.
Address >> has many >> Details Records.
The Details table collects all the other information like terms and maintenance and contracts, etc. This arrangement prevents redundancy among Provider and Address, and gives you the many-to-many relationship between Provider and Address you are seeking.
The two parent records are pulled in to the Details Record via drop down selection lists or Record Pickers.