Form (Subform)

Qasim · #1 03-17-2010, 10:53 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
from new tab - how to copy a form as new subform under new tab	Done	Forms	2	03-04-2010 11:04 AM
Show all recordset in form/subform	Brian62	Forms	4	11-04-2009 08:56 AM
form - subform field mapping	nqirar	Programming	2	03-02-2009 10:49 AM
Form with subform	grgerhard	Forms	0	04-10-2006 08:28 AM
subform and form in Many-2-many relationship	vessii	Forms	0	02-16-2006 06:11 AM