>Hi,
>
>I have come across a situation that I can't seem to resolve and I really need help.
>
>I have a BIZ class based on a cursor adapter for a Purchase Order Header table. The base table for this BIZ class is the P.O. Header.
>
>I have another BIZ class based on the cursor adapter for a Purchase Order Item table. Base table for this BIZ is P.O. Items table. Note that these are two separate BIZ classes even though the P.O. Header table is related to the P.O. Item Table.
>
>If the code need to search records in the P.O. Header table it is easy to do with the CursorFill() method. The same goes for the P.O. Item Table.
>
>The problem is when I need to select records from P.O. Header based on the criteria in the P.O. Item. For example, user want to view all P.O.s where item unit price is greater than $100.
>
>I can't change the design and have a BIZ object based on the two tables. So anything else can be done?
>
>TIA.

You can have some custom Select methods of the parent class that will change SelectCMD on the fly and execute the cursorfill method.