AnsweredAssumed Answered

Logical function calculation

Question asked by sbhex on Sep 2, 2011
Latest reply on Sep 7, 2011 by LaRetta_1

Title

Logical function calculation

Post

Hello everyone,

I'm trying to compose a calculation within a checklist box set to show whether a client is found within a linked table.

Here's what I have so far:

If ( table 1::ID ≠  "" ; "1" )  &
If ( table 2::ID ≠  "" ; "2" ) &
If ( table 3::ID ≠  "" ; "3" ) &
If ( table 4::ID ≠  "" ; "4" ) &
If ( table 5::ID ≠  "" ; "5" ) &
If (table 6::ID  ≠  "" ; "6" ) &
If ( table 7::ID ≠  "" ; "7" ) &
If (table 8::ID  ≠  "" ; "8" )

This works perfectly, but if a client is found in two or more tables nothing appears in the checklist. I've tried doing the same thing with a "Case" logical function but got the same result.

Any ideas?

Thanks

Outcomes