Jim,
In addition to Razzak's suggestion, what I've done is base the grid on a view. If the view contains a variable in the WHERE clause, you should be able to set the variable, then RECALC VARIABLES, then PROPERTY TABLE viewname 'REFRESH'. If that doesn't do what you need, then use the view with the variable in the WHERE clause, and do: PROPERTY TABLE viewname 'CLOSE' DROP VIEW viewname CREATE VIEW viewname .. PROPERTY TABLE viewname 'OPEN' Then refresh the grid. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Monday, August 17, 2009 5:33 PM To: RBASE-L Mailing List Subject: [RBASE-L] - DB GRID I have a form with two tables (Product & ProdPart). The product table is the base table. The second table I put in as a DB Grid. This table has all the parts that go into this product. I want the DBGRID to limit the parts shown to ones where column PACKLIST = 'y'. I gave the MODEL column a Component ID of Model Comp and set a variable vModelEnquiry to Equal that field on the On After Start EEP. This works. Where within the DBGRID would I put the WHERE clause to limit the rows? I have tried making a WHERE clause in the properties columns properties section. Jim
