Same Products Each Time

[tbcomputerguy]

Hi there, i am trying to figure this out...i almost get it, but not quite. I have supplied a file along with this. What I am trying to do is when I enter a new record via the Control sheets, I want to see the list of products show up in the portal. We use the same products for the most part...on some days the products change by 2 or three different ones. As well by the session. I need to when creating a new record after selecting the session, have it show the correct products relating to that session along with their prices. In the portal, i have to enter the returns, extras, etc. and have the total on each line...stuff i can do. I just can't figure out the relationship. I have tried different things and have had the product show up correctly, but when I enter a new record the products table is not updated. There is a screen shot of the excel file we currently use as well.

A little help with this and I think i can do most of the rest of it.

Dave

CONTROL SHEETS2011 ERD.zip