RE: Maintaining #'s between 2 databases

2002-11-04 Thread Cal Evans
uence table. (I did) HTH, =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Mike Patterson [mailto:mp72@;excite.com] Sent: Monday, November 04, 2002 1:19 PM To: [EMAIL PROTECTED] Subject: Maintaining #'s between 2 databases I have two databases (

Maintaining #'s between 2 databases

2002-11-04 Thread Mike Patterson
I have two databases (rt2 & jobs) and within each of these DBs tables that autoincrement email Ticket #'s and Work Request #'s respectively. I'm looking for the best way to maintain the numbers between the databases (e.g. if I had a rt2, jobs, then rt2 requests: rt2 issues ticket #1024, then jo