I am entering data into three fields on a handheld. I have set the DB up to perform a script every time it opens. The script combines the fields 2 and 3 into field 1. If I add data to all 3 fields in FM, the script runs exactly right the next time I open the file. If I add data on the hand held and sync it, the script does not run. The script will run automatically the next time I open the file though. It is as if I needed to open and close the file once for it to recognize the data brought in through the handheld. Any advice? Thanks a lot.

Hi dadioja

what I can't understand is why you need a script to combine field2 and field3...

It seems that all you need is to place a calculation in the AutoEnter/Replace option of field1, something like:

field2 & " " & field3

or

field2 & ¶ & field3 [color:red]( as your post "carriage return" )

Or you have to explain you better...

This is similar to the way a file is opened if it is part of a relationship - the standard startup script does not execute then either.

In the snyc process can you force a script to execute? I don't have FMM7 to comment but I'm sure that was possible in previous versions.

Thanks, I will clarify. Field 1 is a checkbox field. FMM 7 doesn't have that option (as far as I can tell). I can have a drop down menu with one option. So, my solution was to create field 2 and field 3 but only allow user access on the Mobile solution. Then the mobile user has up to 3 choices. When it is brought back to FM7, I have a script that adds field 2 and field 3 to field 1 so the user sees field 1 with the check boxes that were added through the mobile device.

I like the idea of a calculation field. That would solve my problem, but that would not allow the user to change the check boxes in the displayed field once they were in FM7.

I would love to hear a better way to do this since I am sure there is one.

FMM 7 does have a execute script after sync option. That was where I started, but it did the same thing. The data didn't react to the script unless I ran it a second time.

Thanks for any ideas you both have.

Ok, so I figured something out. The rookie move I made is that I didn't realize the script will only apply to current record being viewed. How do I have the script affect all records in the DB?

I figured out the rest. I am doing a loop with all the records. If there is a better way, I would love to hear it, but otherwise, it seems this will work for my needs. Thanks again.