Adding a second auto number field to current table

[gomikem]

Is this possible, and how can I do it?

Adding a second auto number field to current table and auto numbering current entries?

I need to combine some records from the same order number that currently have detailed names. I'm trying to simplify them, but I can't because it creates duplicate records.

 

[Roly Reefer]

Hi,

You can't have two autonumber fields, but you can change your current one to a number field and setup a new one.

HTH,


Roly

 

[neileg]

Orders are usually held in two tables. A header table that holds things like the supplier, the date, the order number, etc. The second holds the detailed lines that make up the body of the order and linked to the header table via the header table primary key. The PK in the header table will usually be an autonumber. When this is held in the detailed lines table as the link, it is held as a long integer and is referred to as a foreign key (FK). The detailed lines table will have its own PK which may well be another autonumber but which is different from the PK in the header table.