I'm a little stuck on how to find a good solution for the following "loop" between the following tables:
The ErrorCode mentioned in Calls and in ServiceOrders are different from each other.
Did think of combining the Calls and ServiceOrders but this is not the solution since Calls and ServiceOrders are different objects ... also the ErrorCode is for the ServiceOrder specific and for the Call (with Serviceordernr) specific.
When adding the ErrorCode information to the ServiceOrders and Calls table also the problem is there of how to make a selection on only the ErrorCode over both tables ...
Also did think of making a seperate table which contains the combination of the ErrorCodes but still there is the problem of 2 different ErrorCodes one for Call and one for ServiceOrder.
If you dont want to link Errorcodes between two tables , then you can use "Qualify / Unqulaify " functions.
You can examples in HELP to demonstarte the same .
Mentioned below is just brief for you :-
The automatic join between fields with the same name in different tables, can be suspended by qualifying the field name with its table name. After qualification of a field name its name will be given in the form of tablename.fieldname.Qualification is switched off by default. It is switched on by means of the qualify statement. It can also be switched off again by means of the unqualify statement.