How do you create an order form where you can enter multiple product line items?

Tags:
Microsoft Access 2007
Microsoft Access forms
I am trying to make an order form in the data base for product.  I want this form to have customer ID and Company name once on the form then numerous qty, item name, and item number lines to be able to type more then one product ordered on the same order form.  I am having quite a bit of difficulty.  Is this possible to do in Access?  Thank you, Wayne

Software/Hardware used:
Microsoft Office, Access 2007

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • philpl1jb
    Yes, it's possible.  I would think that the access sample database would contain something like this. You may also find examples by searching the web. You will be creating two tables .. the order table would contain the one time stuff about an order, order number, customer #, order date, etc.  The second table would contain one row for each item ordered..it would have the order number and the item number and the quantity ordered.  As you said a third table contains the product info and a fourth table the customer info.   You would be creating a form tied to the order file and a subform tied to the order detail. 
    49,970 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following