It sounds like its working as described.
In a layout in Browse mode I want a text to show someones overtime pay.
I think, however, you want a number to show someone's overtime pay, no?
Make it a calculation field (resulting in number) and set the calculation to be as you've described:
Table::RegPay * 1.5
Thanks Nina - yes I meant a txt object showing a number in text format - I guess.
I wanted to avoid adding more fields to the underlying table - which I think is what you are suggesting. I'd have to make quite a few of these fields which I would rather not if there was a simpler way.
I am thinking there isn't - thanks for helping a newbie!!!
If you have FMP11, you can set a global variable to a value and then use a merge variable on the layout.
Set Variable [ $$overtime; RegPay & " * 1.5 = " & RegPay * 1.5 ]
Or if you dont have FMP11 but still have 9 or 10, you can use a web viewer to do something similar. Make sure that you turn off the pen pattern and also uncheck the checkboxes under the web viewer options.
<body style='border: 0; margin: 0'>
& RegPay & " * 1.5 = " & RegPay * 1.5