adding partnumbers to order number

am attaching sample db.
is there a way to add more than one part number on a form?
and not create extra fields?
I have order number, name, and part number. and I want to be able to add 6 to 10 parts to same order number.
thank you
Who is Participating?
HainKurtConnect With a Mentor Sr. System AnalystCommented:
here is what I mention... add a grid/subform to your form to insert parts

HainKurtSr. System AnalystCommented:
you should create another table  

OrderParts (
  OrderNumber Text
  PartNumber Text

and make both columns as primary index

then drop the PartNumber on tblEnter Table

and when you click add, you should loop all parts and insert into OrderParts
HainKurtSr. System AnalystCommented:
also add a relation, and change the column in tblEnter datatype to DateTime
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

davetoughAuthor Commented:
thanks - i see you created a the order parts table- I am getting error in textbox for part number-but that may have been there- did not check my example - before attached
davetoughAuthor Commented:
thank you for help and explanation
HainKurtSr. System AnalystCommented:
I removed the partnumber from main table, thats why you get that error
you should add grid/table/subform to your form to insert parts
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.