Multiple Lines on a Single Return

[JOE POLLOCK]

I have a form that I am developing for use with product returns. I am not
sure how to include more than one entry on my form for customers who return
multiple items on one return. Any suggestions would be helpful and
appreciated.

 

[Al Campagna]

Joe,
Your forms for Returns would be very much like your forms for
Orders.
A main table for Return Customer Information (tblReturnCustomers),
and a related (One to Many) table for multiple items returned
(tblReturnItems).
Subsequently...
A main form, based on tblReturnCustomers, and a continuous subform based
on
tblReturnItems.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[JOE POLLOCK]

Al,
I have created the form and subform in the form wizard, but it still seems
to be creating separate records.

 

[Al Campagna]

Joe,
I don't know what you mean by "separate records"
Please describe in more detail... your tables and your forms.

Does your application have an Order form? That would have a main form
for customer information, and a continuous subform for multiple ordered
items. Your Returns form would use the same basic setup.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."