vanRijn> judd: hey there! =:) judd: how do you handle local database adds? what do you do about the record_id? do you generate one? Hi I just make up a unique number for local use. When I insert it I use 0, and the Palm will create a unique one. judd: do you know, is it possible to do this... retrieve a DB from the palm, add new records and make the record_id for those records max(record_id for the database) +1, consecutively, and then either install that database back to the palm (in which case, I would expect that the palm wouldn't have a problem with keeping the record_ids that were created by the PC application), or adding the records to the database with the reco rd_ids set already? I think that would work. Isn't there a next id field that you would have to bump up also? Actually, I have code that does that. I used pi_file_open, pi_file_append, etc. to do the job. oh? judd: in jpilot you do that? Yes