So, I made up my ERD for class, and I have been trying to implement it into the actual access database, but I am having a problem figuring out how to make each table correctly, For example, when I implement the order table, how can I get multiple items to show up, when I can't use duplicate primary keys.

Sales Vendor PK InvoiceNo VendorlD Quanitiy Varchar (2) FirstName Varchar (20) Varchar (50) Varchar (50) Varchar Extended Last Name Customer_CustomerN FK City Customer State CustomerNo Zip Varchar (20) Varchar (50) Varchar (50) Varchar Name Phone street City State Order Zip OrderNo phone itemname int FK Inventory ISBN Date Date nventory PK FK tem-ID ISBN Varchar (30) Title Varchar Title Quant ity Quantityonhand Cost int Quant ityonorder Extended Order OrderNo Vendor_Vendor Order_item-ID