Dynamic Form (variable number of fields)

[MakinBacon91]

Hello All,

I am having trouble with creating a form for inputting dimensional data.
I am trying to build a form that a user can input the Serial# (SN), and the form will display all of the relevant dimensions to that Serial#, and allow the user to enter values for each dimension.

The Serial# they input will link to a PartType, and the PartType will link to all of the dimensions that are required.
One part type may have 12 dimensions that need to be taken, and another may have 30.

Basically from the tables below, I want the user to select a SN (gives the PartTypeID) and I need to add a new entry to the Dimensions table for every dimension of that PartType in the DimensionList table to the

DimID	PartTypeID	DimName	DimDescription	DimMax	DimMin	DimNom
2	10	A	Outlet ID	18.00	18	18.00
3	10	E	Inlet ID	14.00	14	14.00
4	10	F1	Height	2.02	1.98	2.00
5	10	G	Width	14.65	14.57	14.61
6	10	K	Thickness	17.00	15	16.00
7	10	L	Depth	75.00	72	74.00
8	2	A	Height	12.00	11	12.00
9	2	B	Depth	23.00	24	24.00

<caption> DimensionList </caption><thead>
</thead><tbody>
</tbody><tfoot></tfoot>

DataID	SNID	DimID	Dimension	PassFail
1	336	2	1231
2	336	3	17
3	336	4	18
4	336	5	19	Fail
5		6	1234

<caption> Dimensions </caption><thead>
</thead><tbody>
</tbody><tfoot></tfoot>

I hope this is a decent explanation, but of course let me know if I can explain anything more fully!

Thanks!
-Bacon-

 

[MakinBacon91]

Here is a picture of my relational setup.Pasteboard — Uploaded Image

 

[MakinBacon91]

What do you guys think about creating a temporary table, then use vba to copy the values from that temporary table into the Dimensions table.

 

[Micron]

Had a look, but not crystal clear to me. I can't see the rest of your Job info fields, so I'm not sure - but I suspect theres too much in there. I'm thinking the JobInfo is stuff like job number, who created, when, is responsible, etc. and a JobLineItem is where the serial/part identifiers would go. I also think you'll have issues with your many to one to many relationship between Job-Engine-Dimension relationship. Anyway, as for your question, I'm thinking your main form should have the job header info and a subform datasheet below to input the measurements against the number of dimensions that appear in the list for a given serial.