Is it possible to get a joined table from the PXSelectorAttribute on a field? For instance, if I have the selector defined as below for selecting a customer joined with the contacts for the customer:
[PXSelector(typeof(Search2<BAccountR.bAccountID, InnerJoin<Contact,
On<BAccountR.bAccountID, Equal<Contact.bAccountID>>>>),
SubstituteKey = typeof(BAccountR.acctCD))]
How can I get the Contact record that is joined to the customer that the user selected?
I've tried using the various methods on the PXSelectorAttribute.* but, nothing seems to work.
I also tried setting up Projection to do the join but, that's not working either. The projection table is not being returned by any of the PXSelectorAttribute.* methods.
TIA!