layout number by calculation...

[halbj]

I am trying to use the 'Go to Related Record' script step with the 'show record using layout' option set to 'Layout Number by Calculation...'. My calculation is simple, and I have confirmed that it is in the correct 'context';

If ( Borrowers::Type = "Individual" ; 9 ; 8 )

But, it does not work. I always end up at the layout 8, regardless of the value of 'Borrowers::Type'

If I use the Go to Layout script step and and specify the same calculation it works fine. So there is either an issue with Go to Related Record script step, or something I am doing wrong...

Does anyone have any ideas on this one?

Thanks

[-Queue-]

Do layouts 8 and 9 use the same TO?

[halbj]

yes 8 and 9 use the same TO

[-Queue-]

Can you Stuff and attach the problem file?

[Ugo DI LUCA]

Hi,

Make sure the result of this "find" can be displayed in the desired layout.

I would think you have Set Errror Capture Set to Yes. See if you get some message in this case.

If not, post the file so we can check.

[MoonShadow]

Other considerations ...

Your calculation references a related field. Might there be more than one record relating? If the related Borrower's record (the first one) says Company, your calculation will always produce 8 even though an Individual record exists because the calculation will match the first related record only.

Also, you may have three types of results in that calculation... text equaling Individual, text not equaling Individual and empty. Your calculation will produce 'blank' and your script will not go anywhere because the layout number referenced is blank. I would modify your calculation regardless of how you resolve your problem or be sure 'Do not evaluate if all referenced fields are empty' isn't clicked.