I have a product inventory database same product provided from 2 or 3 suppliers, so i create in a product table a vendor product number and company product number, the idea is to bring one balance in a form or report for a product from 3 different vendor but being same product.
I cannot figure out how to do a query to calculate that.
for example:
These are the fields name:
Product VendorProductNumber CompanyProductnumber Supplier
thank you
I cannot figure out how to do a query to calculate that.
for example:
These are the fields name:
Product VendorProductNumber CompanyProductnumber Supplier
thank you