Subdatasheet Question

crystalda726

New member
Local time
Today, 07:26
Joined
Feb 7, 2005
Messages
6
I have a table for Inventory Items which lists the Item #, Description, Vendor, Pricing, Etc. I also have a table for Inventory Control which lists the quantites in inventory, what was sold and bought, etc. I want to create a subdata sheet in the Inventory Control table, so when you expand it only the information on that item comes up, but when I create the subdatasheet it brings up all the items. How do I create the subdata sheet so only the information I want is shown and not the whole table?
 
Try making a query that selects only the columns you need and use it as the subdatasheet instead of the table.
 

Users who are viewing this thread

Back
Top Bottom