Why can't I put related columns in a Grid header

BLOMASKY

I have a layout with a query of a master table (lets call it Items) and a related query of Sales Orders.

When I select a record in the Items table, it runs a process to store the selected item in LoggedInRegularUser.

In the child query (and yes, auto refresh is selected for when the process that saves the record is run), in the Custom Header, the following works: Sales Orders for: <<LoggedInRegularUser.selectedItem.ID>>
but changing to <<LoggedInRegularUser.selectedItem.ps_Items.ID>> or <<LoggedInRegularUser.selectedItem.sc_Description>>

do NOT display anything. Should this work?

Thanks
Bruce

tford

I haven't tried the situation you are talking about, but in another scenario (I can't remember where), I found that you could not use more than two dots.

As a workaround, you could have a rule that stores the value of: LoggedInRegularUser.selectedItem.ps_Items.ID in a new attribute like: LoggedInRegularUser.selectedItem.ps_Items_ID_Holder

BLOMASKY

Yea, I did that, but it seems a waste to store the same data twice JUST to display it. oh well. there are worse things in life (like a hangnail)

thanks
bruce