LXR Posted March 31, 2005 Share Posted March 31, 2005 I am creating a very simple Checking Account DB, but have run into a problem with the auto entry of a Serial Number. I have 2 tables: (a) Credit Table and (b) Debit Table. I want to auto-enter a single serial number sequence that is shared by both tables. For example: When I create a new record in (a) the serial number is 100. When I subsequently create a new record in (b), the serial number will be 101 etc. Does anyone know how to do this? Link to comment Share on other sites More sharing options...
Robert Schaub Posted March 31, 2005 Share Posted March 31, 2005 See Here Link to comment Share on other sites More sharing options...
Ender Posted March 31, 2005 Share Posted March 31, 2005 Duplicate post. Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Archived
This topic is now archived and is closed to further replies.