Do I need a Many to Many Relationship?

Question

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 would like have the capability of creating macros for rooms and adding estimate components from the Estimate Components table using a record picker. Each estimate component would be related to multiple estimates. The end user would select the room macro they would like to use and simply modify the related components to create an estimate.

------------------------------
Brad Felten
------------------------------

markshnier__you · Answer

Yes, 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
------------------------------

bradfelten · Answer

That worked perfectly!!&nbsp; Thanks for the advice Mark!------------------------------Brad Felten------------------------------

Forum Discussion

Do I need a Many to Many Relationship?