Skip to main content
Question

Do I need a Many to Many Relationship?

  • September 23, 2021
  • 0 replies
  • 23 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------