Thanks Razzak and Bill. I was thinking of the temp view to limit the detail table.
Dan Goldberg From: Bill Downall Sent: Wednesday, October 05, 2011 11:00 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: limit results on a child table in amaster/detail form Dan, The correct syntax also puts the WHERE clause before the ORDER BY clause. ARRANGE ... WHERE... ORDER BY ... Bill On Wed, Oct 5, 2011 at 1:53 PM, A. Razzak Memon <[email protected]> wrote: At 01:20 PM 10/5/2011, Dan Goldberg wrote: I have a master/detail form that I need to put a where clause on the detail portion of the form. I have tried: EDIT USING purordernew arrange shoploc by part ORDER BY vendor# where shoploc.invweek = 'p' It does not work. If I remove the where clause the form opens but not with filtered data. I am thinking I will have to do a view for the detail table(shoploc) but was hoping there was a better way. Does anyone know a better way to do a where clause on a detail table of a form? Dan, FWIW ... In multi-table forms, reports, sub-reports, nested sub-reports, or labels, the WHERE clause is intended for the records for the Master Table, or the table with PRIMARY KEY. All records that match the criteria in Slave table, or table(s) with FOREIGN KEY are automatically displayed based on the Master/PRIMARY Key table. You may limit the records to include in Slave/FK Table by either creating a dynamic TEMPORARY TABLE or VIEW, and then base your form/report on those dynamically defined temporary tables/views. Hope that helps! Very Best R:egards, Razzak. --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
