1. Composite Key (18:00)
Composite Key to Prevent Duplicates

2. Prevent Duplicates (11:11)
No Composite Key
Allow User Option to Add Twice
VBA, DCount
Custom Warning Message

3. SQL NOT IN (9:57)
Remove Products Already On Order From Combo
SQL Not In () Clause

4. Have Not Ordered Part 1 (20:50)
Customers Who Haven't Ordered Specific Product
Text Search on Product Name

5. Have Not Ordered Part 2 (22:43)
Select from Product List
Have or Have Not Purchased

6. Have Not Ordered Part 3 (25:50)
Create Multi-Select ProductList Listbox
ProductList.ListCount
ProductList.Selected(X)
ProductList.Column(0,X)
Recordset Loop Thru Customers
Loop Thru Listbox Selected Items

7. Have Not Ordered Part 4 (35:06)
CustomerTempT for Temp Records
Optimize: Convert For to While Loop
Select All and Clear Buttons
All, Any, and None Conditional Logic
Count Items Selected Function
If No Items Selected Show Nothing