I'm not sure what the problem is. I get the same error when I try making the last 2 relations. The first image is original table and the second is Crow Foot notation of the tables from 4NF.

Customer ID Product Cost Customer Quantity Order ID Customer Order Date Oder Total bsmith1 Bob Smith $ 25 1 1 8/9/2018 $ 70 bsmith1 Bob Smith $ 35 1 1 8/9/2018 $ 70 bsmithi Bob Smith $ 23 1 3 8/12/2018 $ 23 Customer Address 123 Brodway Dr; bsmith@gmail.com 123 Brodway Dr; bsmith@gmail.com 123 Brodway Dr; bsmith@gmail.com 12 Kellogg Ave; jthomas@gmail.com 12 Kellogg Ave; jthomas@gmail.com 5 Maple Street; smith5@gmail.com 5 Maple Street; smith5@gmail.com Customer Email Mail Mail Product Manufacturer Product Subscription Catalogs 1 Catalogs 2 Product ID Product Manufacturer Address Details 1 Spaulding Baseball Basketball Basketball Golf Bastekball-SP Basketball Spaulding Drive 29.5 Inch Lousville 345 Slugger Baseball, Basketball Basketball Golf Bat-L Bat Slugger Avenue 33 Inch 1 Spaulding Baseball Basketball Basketball Golf Bastekball-SP Basketball Spaulding Drive 29.5 Inch 23 Rawlings Baseball Baseball Softball-R Softball Rawlings Court 4 Pack 23 Rawlings Baseball Baseball Bat-R Bat Rawlings Court 32 Inch 1234 Titleist Golf Golf Baseball Golf Balls-T Golf Balls Titleist Road 1 Dozen 1234 Titleist Golf Golf Baseball Bastekball-T Basketball Titleist Road 1 Dozen jthomas1 Jill Thomas $ 6 2 2 8/10/2018 $ 57 jthomas1 Jill Thomas $ 45 1 2 8/10/2018 $ 57 bsmith2 Bob Smith $ 44 2 4 8/12/2018 $ 88 bsmith2 Bob Smith $ 44 2 4 8/12/2018 $ 88 Customer_Email_Subscriptions PK FK Customer ID Subscription PK HPK Prod Manufacturer Product Manufacturer Manfucaturer Address Product Product ID Product Name Product Manufacturer Product Details Product Cost FK PK Customer Customer ID Customer Name Customer Address Customer Emailid Orders FK Customer ID PK Order ID Order Total Order Details PK Order Details ID EK Order ID FK Product ID Quantity Order Date Customer_Mail_Catalogs PK FK Customer ID Mail Catalog 7 Calibri (Detail) BIU A A - ab Text Formatting All Access Obje... Relationships File Home Create External Data Database Tools Fields Table Tell me what you want to do... & Cut Ascending 2 Y Selection - - New tals ab Replace Be Copy Descending Advanced Save Spelling Go To View Paste Filter Refresh Find Format Painter A Remove Sort y Toggle Filter AL X Delete - More Select Views Clipboard Sort & Filter Records Find Relationships CUSTOMER CUST ID - CUST_NAME - CUST_ADDRI - CUST_EMAIL - Click to Add . Search.. #bsmithi Bob Smith 123 Bordway D bsmith@gmail| Tables + bsmith2 Bob Smith 5 Maple Street smith5@gmail. CUSTOMER #jthomas1 Jill Thomas 12 Kellogg Ave jthomas@gmai E CUSTOMER EMAIL SUBSCRIP... * CUSTOMER MAIL CATALOGS ORDER_DETAILS E ORDERS 3 PROD_MANUFACTURER PRODUCT 7 Calibri (Detail) BIU . A - ab Text Formatting All Access Obje... File Home Create External Data Database Tools Fields Table Tell me what you want to do... X Cut | Ascending Y Selection - - New tals ab Replace Be Copy A Descending Advanced Save Spelling Go To View Paste Filter Refresh Find Format Painter Remove Sort y Toggle Filter All X Delete - More Select Views Clipboard Sort & Filter Records Find Relationships ORDERS ORDER_ID, CUST_ID ORDER_TOT,. Click to Add Search.. + + Othomas1 $57.00 Tables 1 bsmith1 $60.00 CUSTOMER 2 bsmithi $23.00 E CUSTOMER EMAIL SUBSCRIP 3 bsmith2 $176.00 CUSTOMER MAIL CATALOGS # 0 $0.00 ORDER_DETAILS E ORDERS PROD_MANUFACTURER PRODUCT + 7 All-X Delete All Access Obje... File Home Create External Data Database Tools Fields Table Tell me what you want to do... X Cut Ascending Y Selection - - New tals ab Replace Calibri (Detail) Be Copy Descending Advanced Save Spelling Go To - View Paste Filter Refresh Find A,ale Format Painter 2 Remove Sort y Toggle Filter X Delete - More BIU A Select Views Clipboard Sort & Filter Records Find Text Formatting Relationships ORDER_DETAILS ORDER_DETAIL ORDER_ID - PROD_ID , QUANTITY - ORDER_DAT - Click to Add- Search.. 1 1 Basketball-SP 1 8/9/2018 Tables 2 O Softball-R 2 8/10/2018 CUSTOMER 3 2 Basketball s 1 8/12/2018 E CUSTOMER_EMAIL_SUBSCRIP... 4 4 3 Goft Balls-T 2 8/12/2018 3 CUSTOMER_MAIL CATALOGS 5 1 Bat-L 1 8/9/2018 ORDER_DETAILS 6 O Bat-R 1 8/10/2018 7 3 Basketball-T 2 8/12/2018 E ORDERS (New) 0 0 PROD_MANUFACTURER PRODUCT 7 Records All Access Obje... File Home Create External Data Database Tools Fields Table Tell me what you want to do... & Cut | Ascending Y Selection - - New Totals abc Replace Calibri (Detail) Be Copy Descending Advanced Save Spelling Go To - View Paste Filter Refresh Find A,ale 2 Remove Sort y Toggle Filter Format Painter BIU A X Delete - More AL Select- Views Clipboard Sort & Filter Find Text Formatting Relationships PRODUCT PROD_ID - PROD_NAMI - PROD_MANI - PROD_DETA - PROD_COST. Click to Add Search.. Basketball-s Basketball Spaulding 29.5 Inch $23.00 Tables Basketball-T Basketball Titleist 1 Dozen $44.00 CUSTOMER Bastekball-SP Basketball Spaulding 29.5 Inch $25.00 E CUSTOMER EMAIL SUBSCRIP. Bat-L Bat Dat Lousville 33 Inch $35.00 CUSTOMER MAIL CATALOGS Bat-R Bat Rawlings 32 inch $45.00 Golf Balls-T ORDER DETAILS Golf Balls Titleist 1 Dozen $44.00 Softball Softball Rawlings 4 Pack $6.00 ORDERS $0.00 PROD_MANUFACTURER PRODUCT Tell me what you want to do.. S New Totals abc Replace Save Spelling Go To Find X Delete - More Select- Records Find BIU A-ay. Text Formatting File Home Create External Data Database Tools Design X Cut 2 Ascending Y Selection Ee Copy Descending Advanced View Paste Filter Refresh * Format Painter A Remove Sort y Toggle Filter All Views Clipboard Sort & Filter Relationships All Access Obje... Search. Tables CUSTOMER_EMAIL_SU... CUSTOMER Y CUST ID CUSTOMER EMAIL SUBSCRIP... SUBSCRIPTION 3 CUSTOMER_MAIL CATALOGS Edit Relationships ? OO Table/Query: PRODUCT Create Related Table/Query: ORDER_DETAILS PROD_ID Cancel PROD_ID Jon Type.. ORDER_DETAILS ORDERS Create New.. PROD_MANUFACTURER 3 PRODUCT CUSTOI CUST_ID CUST_NAN CUST ADD CUST_EMA Enforce Referential Integrity Cascade Update Related Fields Cascade Delete Related Records PRODUCT 7 PROD ID PROD NAME PROD MANUFACTURI PROD_DETAILS PROD_COST Relationship Type: One-To-Many CUSTOMER MAIL CAT Microsoft Access ORDER_DETAILS ORDER DETAILS ID ORDER_ID PROD_ID QUANTITY ORDER_DATE Microsoft Access can't create this relationship and enforce referential integrity. . Data in the table 'ORDER_DETAILS violates referential integrity rules. For example, there may be records relating to an employee in the related table, but no record for the employee in the primary table Edit the data so that records in the primary table exist for all related records. If you want to create the relationship without following the rules of referential integrity, clear the Enforce Referential Integrity check box. PROD_MANU 7 PROD MANUF MANUFACTUR i OK Customer ID Product Cost Customer Quantity Order ID Customer Order Date Oder Total bsmith1 Bob Smith $ 25 1 1 8/9/2018 $ 70 bsmith1 Bob Smith $ 35 1 1 8/9/2018 $ 70 bsmithi Bob Smith $ 23 1 3 8/12/2018 $ 23 Customer Address 123 Brodway Dr; bsmith@gmail.com 123 Brodway Dr; bsmith@gmail.com 123 Brodway Dr; bsmith@gmail.com 12 Kellogg Ave; jthomas@gmail.com 12 Kellogg Ave; jthomas@gmail.com 5 Maple Street; smith5@gmail.com 5 Maple Street; smith5@gmail.com Customer Email Mail Mail Product Manufacturer Product Subscription Catalogs 1 Catalogs 2 Product ID Product Manufacturer Address Details 1 Spaulding Baseball Basketball Basketball Golf Bastekball-SP Basketball Spaulding Drive 29.5 Inch Lousville 345 Slugger Baseball, Basketball Basketball Golf Bat-L Bat Slugger Avenue 33 Inch 1 Spaulding Baseball Basketball Basketball Golf Bastekball-SP Basketball Spaulding Drive 29.5 Inch 23 Rawlings Baseball Baseball Softball-R Softball Rawlings Court 4 Pack 23 Rawlings Baseball Baseball Bat-R Bat Rawlings Court 32 Inch 1234 Titleist Golf Golf Baseball Golf Balls-T Golf Balls Titleist Road 1 Dozen 1234 Titleist Golf Golf Baseball Bastekball-T Basketball Titleist Road 1 Dozen jthomas1 Jill Thomas $ 6 2 2 8/10/2018 $ 57 jthomas1 Jill Thomas $ 45 1 2 8/10/2018 $ 57 bsmith2 Bob Smith $ 44 2 4 8/12/2018 $ 88 bsmith2 Bob Smith $ 44 2 4 8/12/2018 $ 88 Customer_Email_Subscriptions PK FK Customer ID Subscription PK HPK Prod Manufacturer Product Manufacturer Manfucaturer Address Product Product ID Product Name Product Manufacturer Product Details Product Cost FK PK Customer Customer ID Customer Name Customer Address Customer Emailid Orders FK Customer ID PK Order ID Order Total Order Details PK Order Details ID EK Order ID FK Product ID Quantity Order Date Customer_Mail_Catalogs PK FK Customer ID Mail Catalog 7 Calibri (Detail) BIU A A - ab Text Formatting All Access Obje... Relationships File Home Create External Data Database Tools Fields Table Tell me what you want to do... & Cut Ascending 2 Y Selection - - New tals ab Replace Be Copy Descending Advanced Save Spelling Go To View Paste Filter Refresh Find Format Painter A Remove Sort y Toggle Filter AL X Delete - More Select Views Clipboard Sort & Filter Records Find Relationships CUSTOMER CUST ID - CUST_NAME - CUST_ADDRI - CUST_EMAIL - Click to Add . Search.. #bsmithi Bob Smith 123 Bordway D bsmith@gmail| Tables + bsmith2 Bob Smith 5 Maple Street smith5@gmail. CUSTOMER #jthomas1 Jill Thomas 12 Kellogg Ave jthomas@gmai E CUSTOMER EMAIL SUBSCRIP... * CUSTOMER MAIL CATALOGS ORDER_DETAILS E ORDERS 3 PROD_MANUFACTURER PRODUCT 7 Calibri (Detail) BIU . A - ab Text Formatting All Access Obje... File Home Create External Data Database Tools Fields Table Tell me what you want to do... X Cut | Ascending Y Selection - - New tals ab Replace Be Copy A Descending Advanced Save Spelling Go To View Paste Filter Refresh Find Format Painter Remove Sort y Toggle Filter All X Delete - More Select Views Clipboard Sort & Filter Records Find Relationships ORDERS ORDER_ID, CUST_ID ORDER_TOT,. Click to Add Search.. + + Othomas1 $57.00 Tables 1 bsmith1 $60.00 CUSTOMER 2 bsmithi $23.00 E CUSTOMER EMAIL SUBSCRIP 3 bsmith2 $176.00 CUSTOMER MAIL CATALOGS # 0 $0.00 ORDER_DETAILS E ORDERS PROD_MANUFACTURER PRODUCT + 7 All-X Delete All Access Obje... File Home Create External Data Database Tools Fields Table Tell me what you want to do... X Cut Ascending Y Selection - - New tals ab Replace Calibri (Detail) Be Copy Descending Advanced Save Spelling Go To - View Paste Filter Refresh Find A,ale Format Painter 2 Remove Sort y Toggle Filter X Delete - More BIU A Select Views Clipboard Sort & Filter Records Find Text Formatting Relationships ORDER_DETAILS ORDER_DETAIL ORDER_ID - PROD_ID , QUANTITY - ORDER_DAT - Click to Add- Search.. 1 1 Basketball-SP 1 8/9/2018 Tables 2 O Softball-R 2 8/10/2018 CUSTOMER 3 2 Basketball s 1 8/12/2018 E CUSTOMER_EMAIL_SUBSCRIP... 4 4 3 Goft Balls-T 2 8/12/2018 3 CUSTOMER_MAIL CATALOGS 5 1 Bat-L 1 8/9/2018 ORDER_DETAILS 6 O Bat-R 1 8/10/2018 7 3 Basketball-T 2 8/12/2018 E ORDERS (New) 0 0 PROD_MANUFACTURER PRODUCT 7 Records All Access Obje... File Home Create External Data Database Tools Fields Table Tell me what you want to do... & Cut | Ascending Y Selection - - New Totals abc Replace Calibri (Detail) Be Copy Descending Advanced Save Spelling Go To - View Paste Filter Refresh Find A,ale 2 Remove Sort y Toggle Filter Format Painter BIU A X Delete - More AL Select- Views Clipboard Sort & Filter Find Text Formatting Relationships PRODUCT PROD_ID - PROD_NAMI - PROD_MANI - PROD_DETA - PROD_COST. Click to Add Search.. Basketball-s Basketball Spaulding 29.5 Inch $23.00 Tables Basketball-T Basketball Titleist 1 Dozen $44.00 CUSTOMER Bastekball-SP Basketball Spaulding 29.5 Inch $25.00 E CUSTOMER EMAIL SUBSCRIP. Bat-L Bat Dat Lousville 33 Inch $35.00 CUSTOMER MAIL CATALOGS Bat-R Bat Rawlings 32 inch $45.00 Golf Balls-T ORDER DETAILS Golf Balls Titleist 1 Dozen $44.00 Softball Softball Rawlings 4 Pack $6.00 ORDERS $0.00 PROD_MANUFACTURER PRODUCT Tell me what you want to do.. S New Totals abc Replace Save Spelling Go To Find X Delete - More Select- Records Find BIU A-ay. Text Formatting File Home Create External Data Database Tools Design X Cut 2 Ascending Y Selection Ee Copy Descending Advanced View Paste Filter Refresh * Format Painter A Remove Sort y Toggle Filter All Views Clipboard Sort & Filter Relationships All Access Obje... Search. Tables CUSTOMER_EMAIL_SU... CUSTOMER Y CUST ID CUSTOMER EMAIL SUBSCRIP... SUBSCRIPTION 3 CUSTOMER_MAIL CATALOGS Edit Relationships ? OO Table/Query: PRODUCT Create Related Table/Query: ORDER_DETAILS PROD_ID Cancel PROD_ID Jon Type.. ORDER_DETAILS ORDERS Create New.. PROD_MANUFACTURER 3 PRODUCT CUSTOI CUST_ID CUST_NAN CUST ADD CUST_EMA Enforce Referential Integrity Cascade Update Related Fields Cascade Delete Related Records PRODUCT 7 PROD ID PROD NAME PROD MANUFACTURI PROD_DETAILS PROD_COST Relationship Type: One-To-Many CUSTOMER MAIL CAT Microsoft Access ORDER_DETAILS ORDER DETAILS ID ORDER_ID PROD_ID QUANTITY ORDER_DATE Microsoft Access can't create this relationship and enforce referential integrity. . Data in the table 'ORDER_DETAILS violates referential integrity rules. For example, there may be records relating to an employee in the related table, but no record for the employee in the primary table Edit the data so that records in the primary table exist for all related records. If you want to create the relationship without following the rules of referential integrity, clear the Enforce Referential Integrity check box. PROD_MANU 7 PROD MANUF MANUFACTUR i OK