Hi,

I am trying to relate two tables, one contains stock data and is my 'main table'. The other contains operator details. They are linked by the field 'OperatorName' which is a global field in stock and a regular field in Operators (as there are many individual operator records). The Global operator field in my stock database gets its data from a Get(AccountName)startup script.

I am using this relationship to return a value called 'OrderCounter' - a value unique to each Operator.

However, when there are no records found in my Stock table, my button - 'SetField (Operators::OrderCounter = Operators::OrderCounter + 1' - doesn't update the counter. This is a pain as I want this to be available at all times.

Can anyone suggest a solution to this please?

Codeus

I just tested this using a global to text relationship and no records in the parent table. It worked fine. Perhaps your Set Field step is incorrect. You should have no equals sign in it. It should look like Set Field [Operators::OrderCounter; Operators::OrderCounter + 1], the first field being the specified target field and the second, the calculated result.

The Global Operator may not be a global field as you intended.