tables in forms

[michellerobinso]

just a bit of back ground.

my project is to create a database for a warranty dept.

idealy they would like to create a form that allows the basic details

return number,
date,
customer
etc.

put they want to be able to list all the items they get returns.

for instance, a customer may send back multiple products in one box.

at the moment i have a subform set as a table so they can input the product, manufacture etc. but it only lets me do one line of details

 

[RuralGuy]

Hi Michelle,
Could you post the SQL for the Main form and the SQL for the SubForm and what you have in the LinkChild/MasterFields of the SubFormControl? Better yet a little sample db would be nice.

 

[michellerobinso]

Here is a sample

 

[RuralGuy]

Hi Michelle,
Your sample let me enter as many lines in the SubForm as I wanted regardless of whether I completed the top part or not.

 

[michellerobinso]

yes but for every new entry is assigns a new auto number.

i want it to be able to list multiple entries for one return number

 

[ansentry]

michellerobinso,

I don't want to interfere with the advise that you are getting from RG, but you dont have a Form with a true subform. You have 1 table split into two forms.

You at least need;

Cuastomer Table (tblCustomers)
Warranty Items (tblItems)

You will need a 1 - many relationship between the tables. (1 Customer can have many items)

Have a look Here at a simple Main Form SubForm Example that I posted, it may help.

 

[michellerobinso]

thank you for butting in, this is what i want! many thanks for your help!

 

[ansentry]

Glad I could help.

 

[RuralGuy]

Thanks John. That's where I was headed but I was waiting for Michelle to let us know about the many entries for one return number. There are other issues that need to be delt with but I'm sure they will be resolved or we'll be back here again.