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