Is it possible to download field info from laptop to main computer changing the ID

  • Thread starter Thread starter Wayne & Kerri Anne
  • Start date Start date
W

Wayne & Kerri Anne

Hi All

My question is can you import field information from a laptop say which has
the same structure as the table on a main computer.

I have written a vb6 program that has two main tables
One is tblworkorder which has a WOID as the Primary key field (Autonumber)
and the second table tblWorkorderDetail has a WOID as a number field. all
data is linked by the WOID fields.
Is it possible to download this info from the laptop and have the main
computer change the WOID in both tables to the next autonumber of the
tblworkorder of the main computer. and if possible how would one do it in a
kiss system. Very New to access 97.


Kind Regards
Wayne
 
The by far easiest way is to change the autonumber fields from increment to
random
You'll then be very unlucky to get dups (and you can write pretty simple
code to handle that)

Another pretty simple way is the make sure that the On UPDATE Cascade field
is checked for the reference,
update to local WOID by the max(WOID) + 100 (or another suitable increment)
just before the Append
(to make sure you can lock the maintable during the process)

The final way is to Make Recordsets with outer and inner loops handling
WOID's 1 by 1
(Requires pretty good knowledge of VBA/DAO programming)

HTH

Pieter
 
The by far easiest way is to change the autonumber fields from increment to
random
You'll then be very unlucky to get dups (and you can write pretty simple
code to handle that)

Another pretty simple way is the make sure that the On UPDATE Cascade field
is checked for the reference,
update to local WOID by the max(WOID) + 100 (or another suitable increment)
just before the Append
(to make sure you can lock the maintable during the process)

The final way is to Make Recordsets with outer and inner loops handling
WOID's 1 by 1
(Requires pretty good knowledge of VBA/DAO programming)

HTH

Pieter
 
Back
Top