How to create more than two subforms

[Humble]

Hi,

Can anyone help with creating subforms in Access 2007? Thanks.
I am creating database for my coating experiments. Here is the idea:
Each coated film may have one layer or two layers or three, each layer
has different composition and configuration. I would like to creat a
form show up all info of each coated film including each layer. I
created a master table stored info. with films and 1st layer table,
2nd layer table etc.
Basically I selected data by film ID from master table and 1st layer
table....., I can create a subform from 1st layer table, what about
2nd layer table and 3rd layer table if the film has more than one
layer. Do I need to write to do it?
Appreicate any suggestion.
Thanks.

 

[Jerry Whittle]

Well you shouldn't have a table for each layer. All the layer's should be in
one table.

 

[John W. Vinson]

Hi,

Can anyone help with creating subforms in Access 2007? Thanks.
I am creating database for my coating experiments. Here is the idea:
Each coated film may have one layer or two layers or three, each layer
has different composition and configuration. I would like to creat a
form show up all info of each coated film including each layer. I
created a master table stored info. with films and 1st layer table,
2nd layer table etc.
Basically I selected data by film ID from master table and 1st layer
table....., I can create a subform from 1st layer table, what about
2nd layer table and 3rd layer table if the film has more than one
layer. Do I need to write to do it?
Appreicate any suggestion.
Thanks.

Your table design is incorrect. You should have *ONE* table for all the
layers, with a LayerNumber field; if you have three layers you'll add three
records, if you have eighteen you'll add 18.

You can display the three layers on three separate subforms if you wish, by
basing each subform on a Query selecting one particular layer, but as a rule
this shouldn't be needed.