nminaker
Technical User
- Jun 17, 2004
- 19
I am in the middle of creating a database of products which go in different "kits." The kits are seperated by their own numbers and many of the kits contain the same products. All the products have a specific product number and product description.
What I would like to do is have one table with all the products that will possibly go in the kits(two fields, ProductID and Description) and another table with all the products in all the kits. (ProductID, Description, Kit#, ExpDate... etc). For the second table I would like the Description to autofill or fill somehow with the description in the first table. Is this possible at all?
Thanks!
Nick
What I would like to do is have one table with all the products that will possibly go in the kits(two fields, ProductID and Description) and another table with all the products in all the kits. (ProductID, Description, Kit#, ExpDate... etc). For the second table I would like the Description to autofill or fill somehow with the description in the first table. Is this possible at all?
Thanks!
Nick