Here's a fun 1

[asgweb]

I have a drop down menu 'CharityChoice'. If user chooses 1 of the options, I'd like to populate

'PaymentName' (text box) with a name and address.

Here's what I have but FM is giving me an error that says " the field 'SalvationArmy' is not found"

It would also be nice to add carriage returns in the address.

Thanks in advance for your help

Substitute( CharityChoice = SalvationArmy , Salvation Army 123 So First St SLC UT 84111,

CharityChoice = RescueMission , Rescue Mission 555 2nd st SLC UT 84372

)

[IdealData]

Please look at the syntax for the SUBSTITUTE function in the help system as you seem to have completely ignored it.

Your calculation appears to be trying to make a selective choice so look also at the CASE and IF functions too.

Are you still really using FMP4? - How are you doing this on Leopard?

Have fun!

[FM Tid]

Supposition: Leopard is running on an Intel Mac, with Classic / OS 9.2.2 running FM4 using Parallels or an equivalent emulator?

If that is not the answer then please say how you are doing it, as one day I will need to buy an Intel Mac yet still be able to run my Classic apps including FM2...