I have a setup where there is a master table which is related via CaseNo field to three child tables.
For each master record, there will be data in only one of the child tables.
Using only one detail line, I need to include data from the master table and the child table that is not at end of file. I need to get the data from the proper child while in a formula.
Example:
IIF(NotEOFChild1Condition, Child1.data,
IIF(NotEOFChild2Condition, Child2.data,
IIF(NotEOFChild3Condition, Child3.data,0)))
IsNull({ChildN.data}) didn't work.
Neither did Len(Trim(CStr({ChildN.data}))) > 0.
How do I go about this?
For each master record, there will be data in only one of the child tables.
Using only one detail line, I need to include data from the master table and the child table that is not at end of file. I need to get the data from the proper child while in a formula.
Example:
IIF(NotEOFChild1Condition, Child1.data,
IIF(NotEOFChild2Condition, Child2.data,
IIF(NotEOFChild3Condition, Child3.data,0)))
IsNull({ChildN.data}) didn't work.
Neither did Len(Trim(CStr({ChildN.data}))) > 0.
How do I go about this?