>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,
In your grid's query put:
SELECT blah, blah, blah ;
FROM blah ;
WHERE blah=?thisform.pageFrameName.listboxName.Value
Put in the InteractiveChange event of the drop-down:
thisform.pageFrameName.Grid.Refresh or Requiry
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only