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. > ==============================**================== > > >
