Steepleboy04
Registered User.
- Local time
- Yesterday, 22:34
- Joined
- Aug 3, 2006
- Messages
- 11
I am trying to create a database that generates a msds document for our products.
I have three tables so far:
TBL_MSDS
ID (PK)
ProductCode
ComanyName
TBL_ProductCode_Ingredient
ProductCode
IngredientID
TBL_Ingredient
IngredientID
CAS#
I've created a form that has default values for company information and other first aid procedures(I did not list these fields to save space).
I want to be able to enter the product code on one tab, then on the next tab I would like to select from a list of Ingredients that the product may contain. I should be able to select as many ingredients as I like---and when I select an ingredient, its CAS# is automatically entered as well.
Then I would like to print a report based on this form.
I am not familiar with VBA. Also, I am not sure how to link more than one table to form, and how to select certain records based on user entry.
Any help would be appreciated.
Thanks.
I have three tables so far:
TBL_MSDS
ID (PK)
ProductCode
ComanyName
TBL_ProductCode_Ingredient
ProductCode
IngredientID
TBL_Ingredient
IngredientID
CAS#
I've created a form that has default values for company information and other first aid procedures(I did not list these fields to save space).
I want to be able to enter the product code on one tab, then on the next tab I would like to select from a list of Ingredients that the product may contain. I should be able to select as many ingredients as I like---and when I select an ingredient, its CAS# is automatically entered as well.
Then I would like to print a report based on this form.
I am not familiar with VBA. Also, I am not sure how to link more than one table to form, and how to select certain records based on user entry.
Any help would be appreciated.
Thanks.