I am working with access 2013 to make a database for to doent purchase orders. My Fields are: order #, date, vendor, items, quantity, unit price, and total price.
My problem is there are some orders that have multiple items in them. How do I make the database without making it have a table for every purchase order?

I need to figure this out, any help is greatly appreciated.