Multiple Lines on a Single Return

  • Thread starter Thread starter JOE POLLOCK
  • Start date Start date
J

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.
 
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."
 
Al,
I have created the form and subform in the form wizard, but it still seems
to be creating separate records.
 
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."
 
Back
Top