I am new to Access and is currently working on an inventory database. I have tables such a Pricelist, Vendor, Outlet Name.
There are ten queries for each Outlet selected from Outlet Name table. Each qry Outlet has a list of no less than 80 records that include ProductID, ProductName, Description, Price, Quantity and Total. Is it possible to create one form to select from the Outlet Queries and display all records for the individual outlet? If this is possible could someone please give me an formula that I can use to make this selection in the form? Any help will be greatly appreciated.
There are ten queries for each Outlet selected from Outlet Name table. Each qry Outlet has a list of no less than 80 records that include ProductID, ProductName, Description, Price, Quantity and Total. Is it possible to create one form to select from the Outlet Queries and display all records for the individual outlet? If this is possible could someone please give me an formula that I can use to make this selection in the form? Any help will be greatly appreciated.