Dan,
FWIW, in a report/form with Master and Slave Tables, the WHERE clause is
only pertinent to the Master table.
Alternatively ...
1. Based on your application and the desired results, you could prepare
the salve table(s) as *TEMPORARY tables/views *with the matching data
you need, dynamically, and then use those slave tables/views in reports
with your master table *WHERE clause*.
2. If appropriate, depending on the desired results, you could use the
*Custom Table Relationships* to limit the data from Slave Table. See
attached screenshot, for example. There are more complex examples to
customize all kind of requests.
That's how I do it, in a situation like yours!
Razzak
On 12/29/2022 5:20 PM, Dan Goldberg wrote:
I have a command to run a report
PRINT reportname ARRANGE slavetable BY colmun ASC ARRANGE
slavetable2 BY column2 ASC, column2 ASC where serial = 333631 ORDER BY
serial OPTION SCREEN
I would like to use a where clause on stdequipvw in the report
parameters which is a slave table. is there a way to do that or do I
just use a temporary view to use as a slave table that has my where
clause?
Dan Goldberg
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/5ded4c6e-50ef-f258-a694-f0991f67d287%40rbase.com.
