Sub Forms help

Okay so I have a form this form is such that it has say a clients name , then I need a subform so that I can add custom images that this client has with me, then I need to add all of the products that are made with each custom image.

I am trying to use sub forms, which work for the data entry but when I go back to view the client none of the images and products I entered are there. They are added to the table but that is it.

Any suggestions?

Basically it breaks down to I need a form that has 'A' (main)
'B' (secondary) with the ability to add multiples to the entry, and 'C" (conects to 'B') with the ability to add multiples under each 'B'.

Personnaly I don't like subforms, but...

two forms

Form1
MainForm with A data
with a subfrom with B data

Form2
MainForm with B Data (using a filter of A data ID)
witha subform with C data


S-

I need this as one form.

If you dont like subforms then how would you do this? I am open for suggestions.

What is the breakdown of you data structure for these three tables?

S-

Okay so here is what I need. I have three things that need to be shown on a one form, they can be seperate tables or what ever.

I have the clients name. I also have a large list of images, these can be unique, the image list grows all the time though. Then I have a products list. Each client can have a variety of images that then have a variety of products.

I want to input on a single for the clients name, then each image they have, and each product for each image.

So it is something like this:

A
+B.1
+c.1.1
+c.1.2
+c.1.3
+b.2
+c.2.1
+c.2.2
+c.2.3

Let me clarify

I need the data structure (field list) of your three tables that you using for store the info that you will enter on the form

S-

Museum Name

Image List

Products List

So any further help on this? thanks

Let me clarify so more

This is an example of what I need

Table1
CusomterID (PK)
CustomerName
CustomerAddress

Table2
OrderID (PK)
CustomerID (FK)
Terms

Table3
OrderID (PK/FK)
ItemID (PK/FK)
Qty
Price



S-

I only have 3 things required for this:

Museum Name

Image Name

Products List

These can be separate tables or individual. I just need them to be able to be inputed on one form and I need it to allow for Multiple images under each museum and multiple products under each image.

Other than that I am open for guidence as how best to make this form and tables.

Look at the northwind Sample database.

Look at the from [Customer Orders]

It has two sub forms on one form that are linked together and work together.

S-

Where do I get the northwind Sample database?

Found it thanks

I just can not figure it out. I have enclosed a DB with 3 tables I need a form for this so that I can add multiples to each customer for the images table and then add multiples of each product for each image. I looked at the DB sample you told me too and then tried to rebuild it but it would not work. I must be doing something wrong in the form builder.

Please help...........

Thanks

If I have time over the weekend, I will look at it and see what I would suggest.

S-