I have a table “tblParts”. I have 10 different types of parts. Each part type has 10 unique properties (about 20 common properties for all type of parts). So, I have decided to store the unique properties in table with columns “Property” and “Value”. (Please comment is it right approach?)
Eg.1
tblPart
Part id -- Part Type -- Part name -- Part colour -- Part Manuf
================================================== ===
1------------ANZ ----------Safe Box----- Green ----------------LB
tblPartdetails
Id --Partid--- Property---- Value
=============================
1 -----1 --------Angle---------- 45
2 -----1 -------Finishing---- Clear
3 -----1 -------Cladding---- Chrome
(1 to many relation between tblPart and tblPartdetails)
How do I create forms to add and update this type of table?
I have proceeded with creating Mainform for the common properties (tblPart) and subform for unique properties (tblPartdetails). The subform is in datasheet type form.
In the first column of the subform I am planning to populate the properties depending on the selected Part type in the mainform.
I struck up in this. I want to insert the following in AfterUpdate event in the Part type combo box of the mainform.
Me!subform1.Form!Property = <list of properties for the selected part type> in the first column of the subform, so that user enter the property value in the second column.
I donot know how do I populate each property in each row of the first column.
Any help and suggestion is much appreciated for the following
1) Is this approach of table design correct?
2) Is this approach of form design correct?
3) How do I populate 10 properties in first column of the subform (one property in each row)
Thanks