AnsweredAssumed Answered

Displaying Many-to-Many Relationships

Question asked by Gasser on Oct 22, 2010
Latest reply on Oct 25, 2010 by philmodjunk


Displaying Many-to-Many Relationships


I manufacture nine items. Each has five basic cost factors: a. Raw Materials, b. Manufacture/Assemblage,
c. Packaging, d. Distribution, and e. Advertising. I have separate tables for each of these tables with datarows for each of the nine items. How should I construct a many-to-many database which would enable me to query one of the nine items and see the five cost factors for that item displayed on one page?
Could anyone help me? Many Thanks, Gasser