Do I need a Many to Many Relationship?
I would like to build a cost estimator table where macros are set up for estimates. I have two tables: Table 1. Estimate Components (ex. floor cover, tile) and Table 2. Rooms (ex. Living Room). I wou...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYes, that will be a classic many to many relationship with a middle "Join" table
One Room has many Room Components.
One Component is used for many Room Components.
The middle table "Room Components" will have fields for the qty and the unit price.
The Room Form Form will have an embedded report of Room Components used for that Room
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
One Room has many Room Components.
One Component is used for many Room Components.
The middle table "Room Components" will have fields for the qty and the unit price.
The Room Form Form will have an embedded report of Room Components used for that Room
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
That worked perfectly!! Thanks for the advice Mark!
------------------------------
Brad Felten
------------------------------
------------------------------
Brad Felten
------------------------------