AnsweredAssumed Answered

Case statement or script?

Question asked by DavidCampbell on Dec 7, 2010
Latest reply on Dec 8, 2010 by DavidCampbell

Title

Case statement or script?

Post

Hiya,

I'm trying to do the below and it's not working. Any assistance would be very much appreciated:

Case (TableA::ThisYear = "Yes" and not IsEmpty ( TableA::Field1 ) and not IsEmpty ( TableB::Field2 ) and TableA::Field1 = TableB::Field2;TableA::Field1;
TableA::ThisYear = "Yes" and not IsEmpty ( TableA::Field1 ) and not IsEmpty ( TableB::Field2 ) and TableA::Field1 ≠ TableB::Field2; TableA::Field1 & " " & TableB::Field2)

The fields contain only text and are coming from portals in two layouts which I need to combine in a third portal/layout.

Outcomes