Hello,
The formulations for my company's products are contained in individual word documents. I want to enter this data into an Access DB and recreate the format of the formulation sheet as much as possible.
Each product has multiple raw material ingredients that each can have multiple options for that ingredient. Examples are attached. A product can have up to 8 ingredients and each ingredient can have have to 4-5 different options (from alternate suppliers, equivalent raw materials)
Is it possible to make an Access report look like one of the attached? The product information has a one to many relationship with the % formulation lines, which have a one to many relationship with the raw material options for that %.
Thank you!
The formulations for my company's products are contained in individual word documents. I want to enter this data into an Access DB and recreate the format of the formulation sheet as much as possible.
Each product has multiple raw material ingredients that each can have multiple options for that ingredient. Examples are attached. A product can have up to 8 ingredients and each ingredient can have have to 4-5 different options (from alternate suppliers, equivalent raw materials)
Is it possible to make an Access report look like one of the attached? The product information has a one to many relationship with the % formulation lines, which have a one to many relationship with the raw material options for that %.
Thank you!
Attachments
-
Formulation Sheet Example 1.png -
Formulation Sheet Example 2.png
