Hi Board,

 

I have a table, that logs a Time and a Works Order number.

 

I have another instance of that table, used for a user interface layout. It has a self join that i am using to do a count of Works Order.

 

So, in the User Interface, there is a portal of the self join that shows all the records with the same Works Order as in the original table.

 

I want to make a field that is a Calculation (Count) of the self joined table.

 

But, on adding this field, i cannot select the other instance of the table because its not Related to the Original instance. 

 

What am i doing wrong here? It tells me I cannot use a non related field or that it should be a global field. Ive changed it to a global field storage type but that hasn't cleared the error message.

 

Thanks for any help.

 

Harry

In the Edit Calculation dialog, note the popup "Evaluate this calculation from the context of". The default TO is the first TO created for that table, which in your case obviously is not the correct one.

 

Choose a TO that is related to the table whose records you want to count, i.e. (IIUC) the TO your UI layout is based on.

D'oh!

 

I'm only just learning about TO's, splitting up tables and connecting TO's in different ways for different calculations.

 

Thank you so much!