Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Local Parameterized Views...
Message
From
18/05/1997 15:45:52
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00032722
Message ID:
00032724
Views:
29
>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
Map
View

Click here to load this message in the networking platform