You'll need to share the actual script so that we can see the details instead of just an outline.
My guess is that Field A and Field B are not defined in the same table. Either that or if they are from the same table, you did not use the same table occurrence name to refer to each field. But I can only guess from the info so far provided.
To post a script to the forum:
- You can upload a screen shot of your script by using the Upload an Image controls located just below Post a New Answer.
- You can print a script to a PDF, open the PDF and then select and copy the script as text from the opened PDF to your clipboard for pasting here. (with this approach, you can get multiple script steps on the same line, please edit the pasted text by inserting some returns to separate those steps.)
- If You have FileMaker Advanced, you can generate a database design report and copy the script as text from there.
- If you paste a text form of the script, you can use the Script Pretty box in the Known Bugs List database to paste a version that is single spaced and indented for a more professional and easier to read format.
Thanks for your reply.
After getting some sleep and doing another test I realised that I must have triggered the script twice instead of just once as it had no failsafe to stop empty cells from being copied over. As the script now runs fine with no modifications made, its the best explanation for what must have happened. That's what I get for overt thinking things :)