I am not much familiar with sql in vba, I'm still learning. This is what I currently have in the db,
tbl_vendor
-ID (PK)
-Vendor Names
tbl_vendorinvoice
-Vendorname (Dropdown list from tbl_vendor, saves number as a referance to one of the record from tbl_vendor Vendor Names).
how should I put...