AnsweredAssumed Answered

BIG CALCULATION PROBLEMS

Question asked by user14830 on Jun 22, 2010
Latest reply on Jun 22, 2010 by user14830

Title

BIG CALCULATION PROBLEMS

Post

Hello again!

 

I'm using FM11

 

I am trying to have a specific field paste the contents of the first field that has a value entered in it, but it needs to go in a specific order.  All of these fields are on the same layout and in the same table.

 

Here's my script I have now...

 

If [Hands::BBA1 = "C" and Hands::SBB1 ≥ ""]

Set Field [Hands:BBB1 ; Hands:SBB1]

End If

 

If [Hands::BBA1 ="C" and Hands:: SBB1 ≤ ""]

Set Field [Hands::BBB1 ; Hands:BB1]

End if

 

If [Hands::BBA1 = "C" and Hands::BB1 ≤ ""]

Set Field [Hands::BBB1 ; Hands::COB1]

End If

 

If [Hands::BBA1 = "C" and Hands::COB1 ≤ ""]

Set Field [Hands:BBB1 ; Hands::MB1]

End If

 

If [Hands:: BBA1 ="C" and Hands::MB1 ≤ ""]

Set Field [Hands::BBB1 ; Hands:: UTGB1]

End If

 

At first, this appeared to work.  But I noticed if the script had to skip a few too many then it wont work.  Is there a more "sophisticated" solution to this??

 

Thanks for you help.

 

Fred

Outcomes