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
