When I perform a find in my database and then synchronize my handheld, all records show up on my handheld instead of just the found set that I wanted.
This is because the synchronization process occurs in its own session and does not necessarily have the same found set as the one you see in your open copy of the database. The resolution is to explicitly define the desired found set in a script that is configured, in the FileMaker Mobile 8 administration panel, to run at synchronization time. This will ensure that the found set that is loaded into your handheld is what you expect it to be.
You could write a one-line script with a find request for records set as yours, or perhaps with a specific status, and so on. FileMaker Mobile will run the script, establish the found set you need, and synchronize just those records.
If youd like to be able to synchronize the found set you have showing on your own computer, youd need to write a routine for flagging your fields in a particular way, and then searching for that flag in the script tied to synchronization.
When I add new records to my handheld, they don seem to have ID numbers. These usually fill in automatically when I add a new record on my computer. Then when I perform a synchronization, the IDs are missing in my FileMaker Pro database as well.
Auto-enter functions are not performed when records are added to a master FileMaker database via handheld synchronization. Your best option is to populate these numbers manually with a script that is configured to run after synchronization. Heres a script that will do this:
Perform Find [ Specified Find Requests: Find Records; Criteria: fixme::id: "=" ] [ Restore ] Replace Field Contents [ fixme::id; Replace with serial numbers: Entry option values] [ No dialog; Update Entry Options ] Exit Script [ ]
Help! I deleted unnecessary records from my handheld and then synched, but now those records are missing on the master database on the server.
It is very important to remember that FileMaker Mobile 8 on your handheld will give you the option of deleting records from your source or desktop/hosted database. It is also important to keep in mind that cascading deletes based on relationships are also performed as a result of deletions performed on your handheld. It is highly advisable to make backups of synchronized data often using FileMaker Servers backup routines or manually, in the case of single-user files.
How can I have the records that I synch to my handheld sorted in a specific order?
Records are transferred to your handheld at synchronization time in the order in which they exist in the synchronization session. Thus, lets say you want your data automatically sorted by last name and then by first name when it reaches your handheld. Simply have your presynch script perform that sort for you.
Keep in mind, however, that there is no unsort function on your handheld version of FileMaker Mobile 8, so if you choose to sort your data, it will remain sorted in that order by default.
Part I: Getting Started with FileMaker 8
FileMaker Overview
Using FileMaker Pro
Defining and Working with Fields
Working with Layouts
Part II: Developing Solutions with FileMaker
Relational Database Design
Working with Multiple Tables
Working with Relationships
Getting Started with Calculations
Getting Started with Scripting
Getting Started with Reporting
Part III: Developer Techniques
Developing for Multiuser Deployment
Implementing Security
Advanced Interface Techniques
Advanced Calculation Techniques
Advanced Scripting Techniques
Advanced Portal Techniques
Debugging and Troubleshooting
Converting Systems from Previous Versions of FileMaker Pro
Part IV: Data Integration and Publishing
Importing Data into FileMaker Pro
Exporting Data from FileMaker
Instant Web Publishing
FileMaker and Web Services
Custom Web Publishing
Part V: Deploying a FileMaker Solution
Deploying and Extending FileMaker
FileMaker Server and Server Advanced
FileMaker Mobile
Documenting Your FileMaker Solutions