I have the following items in the database
Tables
1. tbl_VendorList (ID=PrimaryKey, Vendors(Names)
2. tbl_VendorInvoice (Vendor field = [ID from Table 1] you can see the names but they're all connected to VendorList tbl, also contais other information)
Queries
1. frm_Search
Forms
1...