Hi Listers, I've build an outer join between a view form fed with data from an external system by the Oracle SQL Loader and a regular form.
The idea was to run an escalation on the outer join to mark records having no corresponding records in the regular form, i.e. new data for my regular form, in order to trigger a filter that would push the new data into the regular form. For some reason the join is protesting, when the filter pushes the id being part of the join's criteria into regular form. What am I doing wrong and what options do I have. I prefer not to use direct SQL. Thanks Mark _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
