I need some help in setting up a subdatasheet based on table. I have a Products table which contains all of my inventory items and also has a subdatasheet which references the Inventory Transactions table. My Inventory Transactions table reflects items that have been disbursed on a certain date.
What I am trying to do is have a separate table called Career Fair Giveaways which lists college name and dated visited. I want to be able to have a subdatasheet which expands in this same table and shows the Inventory Transactions table data based on query data.
I'm really lost on how to make this happen. I would so appreciate anyone assisting me in how to get to get started.
Thank you.
What I am trying to do is have a separate table called Career Fair Giveaways which lists college name and dated visited. I want to be able to have a subdatasheet which expands in this same table and shows the Inventory Transactions table data based on query data.
I'm really lost on how to make this happen. I would so appreciate anyone assisting me in how to get to get started.
Thank you.