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