I am overriding the prodtable_ds query on the prodtable form.  I would
like to filter out the results for only the person logged in user
curusrid().  To do this I am trying to select all records where
prodtable.createdby == curusrid() || prodtable.modifiedby == curusrid
().

I basically have 2 questions:

1. Is this the best way to do this, or should I be looking elsewhere
to filter my results.

2. If this is the best way, can this be done at all?  The problem I am
having is that when I append a range to the query it automatically
appends it and an "and" instead of an "or".

I want the query to be equvalent to
prodtable.createdby == curusrid() || prodtable.modifiedby == curusrid()
but instead the default value is this:
prodtable.createdby == curusrid() && prodtable.modifiedby == curusrid()

Is there any way for me to have an or for these two fields ??

Thanks.






Yahoo! Groups Links

Reply via email to