Steepleboy04
Registered User.
- Local time
- Today, 15:05
- Joined
- Aug 3, 2006
- Messages
- 11
I am having trouble with my database structure on this project. Please look at my DB (relationships) and let me know what is incorrect.
My MSDS tbl appears to have lots of fields, however, the values of these fields are already determined and will not change.
The Product_Ingredient tbl is meant to link three tables; MSDS, PRODUCT, INGREDIENTS.
The purpose of the Product frm is enter and view the fields of the tblProduct (code, name, type use) and the tblIngredients (name, cas_no, voc, hap).
The purpose of this database is to generate an MSDS report for each Product (searchable by product) and the report must list the Ingredients and its percentage for each respective Product.
I've had some feedback already on this db. Maybe you can help.
Thanks.
Lutz
My MSDS tbl appears to have lots of fields, however, the values of these fields are already determined and will not change.
The Product_Ingredient tbl is meant to link three tables; MSDS, PRODUCT, INGREDIENTS.
The purpose of the Product frm is enter and view the fields of the tblProduct (code, name, type use) and the tblIngredients (name, cas_no, voc, hap).
The purpose of this database is to generate an MSDS report for each Product (searchable by product) and the report must list the Ingredients and its percentage for each respective Product.
I've had some feedback already on this db. Maybe you can help.
Thanks.
Lutz