[AccessD] Multiple Users Question - Replicated Database

Hi,

I am kind of stuck on an issue and wondered if anyone has done this.

My housing inspection software is being used locally and is working great.

However, when I wrote the software, they were only using one tablet pc and
replicating with the master copy on the server.

Now they want to send multiple inspectors out there with tablet pc's.

My problem is that when they create an inspection, I assign a unique
inspection id.  That id follows the record through the inspection process,
and then onto the Work Order that is created when there are repairs needed.

If I have multiple inspectors with tablet pc's, I can't create the unique
inspection id (automatically increments by one) when the inspection is
created on the tablet pc, because I won't know which id each of the tablet
pc's are using until the users synch with the copy on the server.  

Multiple inspectors means duplicate inspection id's.

Is this making sense?

I need a way to create a temporary inspection id that is unique and then
when the inspector synchs with the server, a permanent id is assigned to the
record.

Anyone run into this?

Is this the way to go about doing this?

I'm not necessarily looking for code, just some opinions.

Julie Reardon
PRO-SOFT of NY, Inc.
44 Public Square, Suite 5
Watertown, NY  13601
Phone:  315.785.0319
Fax:  315.785.0323
NYS IT Contract#CMT026A
NYS Certified Woman-Owned Business
www.pro-soft.net