>>>Do you want to select fields from the Details table as well? E.g. can you select the same fields (PO Header only) but set SQL statement to use both tables to specify both conditions?
>>
>>No, I don't need to select fields from Details table. Just to have it in the SQL Select (as in LEFT JOIN ...). I will have to test it. Your last sentence would be what I am looking for except you put a question mark at the end. Which I interpret that you are not sure (and if you are not who is?! <g>)
>
>Yes, that's my style, actually. I'm usually not 100% sure in all my suggestions, so I word them as questions. When I'm 100% sure I most likely will end up with the . at the end.
The test works! I can't thank you enough. I have to do some custom changes but I don't have to redesign my BIZ classes; which is a big help. Btw, my reference to LEFT JOIN above was wrong. I can't do that because the CursorFill has to "see" the same fields as defined in the schema. So I am going to use the sub-query (is it derived query method; again, I am confusing terminology). Basically my SQL Select will be:
select A.field1, A.field2... from A where A.pk in (select B.pk from B where B.field1 = 'somevalue')
Again, thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham