Hello There,
This is what I'm trying to do, and I think it's possible:
I have a drop-down list box that contains a list of stores with their associated StoreId's. I want to create a grid(using a view) on my form that displays all the items a particular store has. I have two tables. StoreItems and Items that are linked via an ItemId. What I need to do is on the InteractiveChange event of my drop-down, refresh the grid with the correct store items by passing the view the StoreId. I can't seem to figure out how to do that.
Thanks,