|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 22nd, 2005, 12:13 PM
|
|||
|
|||
Autonumber Fields
Access allows a table to have an autonumber field which could be considered a
record number. In an application I am involved in developing there are a number of code tables which are using the autonumber field as the code. This is autonumber code is then used in the tables holding the data. I am seeking opinions on this approach. Is this a reasonable practice? What are the dangers of doing this? I come from a mainframe environment where this sort of approach is avoided by generating a unique code value which is not an effective record number as a record is added. -- Denis 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Sorting a table by concatenating several fields in the same table | salsaguy | Running & Setting Up Queries | 3 | March 6th, 2005 08:41 PM |
| Sorting a table by concatenating several fields in the same table | salsaguy | Running & Setting Up Queries | 0 | March 6th, 2005 01:33 AM |
| Additional fields for form based parameter query/null fields | geeksdoitbetter | Running & Setting Up Queries | 2 | January 7th, 2005 10:05 PM |
| Selecting Fields for Update | Steve Daigler | Page Layout | 4 | October 15th, 2004 02:13 PM |
| My tables lost their AutoNumber fields | Bill Nicholson | Database Design | 2 | July 2nd, 2004 02:20 AM |
Threaded Mode