On 10 March 2010 02:02, Richard S. Russell <[email protected]> wrote:
> Any advice on how to handle upgrades that will permit (a) tutor data entry
> during normal use and (b) periodic additions from the central office?
In terms of identifying records, you simply need a unique ID. For this
you can use an auto-enter calculation that will generate unique IDs on
each machine, eg:
UID = Filter (
Get ( RecordID ) & "-" &
GetValue ( Get ( SystemNICAddress ); 1 ) & "-" &
Get ( CurrentTime );
"0123456789-" )
Each database can still have a FileMaker serial-number ID field if you
want, but your UID field is what you can import from one database to
another without clashing.
You'll still have to solve issues of distribution and duplication of records.
HTH.
--
Tim Mansour <[email protected]>
Certified FileMaker 10 Developer
