At 05:33 PM 8/17/2009, Jim Belisle wrote:
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 sectionJim,
Jim,
You cannot limit the matching rows in a form with One/Many
relationship criteria. WHERE clause is applicable to primary
table and not the slave table(s). You may sort the records
for slave table(s) using the ARRANGE BY Clause.
In your specific scenario, change the DB Grid to a Variable
Lookup ListView.
Then, you can design a cool interface with a dynamic WHERE
clause for Variable Lookup ListView.
Very Best R:egards,
Razzak.
