Razzak, I have used the Listview feature in other places so I should be able to figure that out. Can you have one list view based on another listview? I want to be able to limit rows not only as mentioned below ( = 'y') but then want a separate listview sowing the inventory amounts to come up.
If I can do that, my next step is to have calculations so sales can quote specific products with a quantity. The form will come up, calculate first the number of pieces needed to fill the quote then calculate if we have enough inventory on hand to determine a quick ship date. Jim -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Monday, August 17, 2009 4:45 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: DB GRID 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.
