auto filling ID # field that was added

[russi]

Hi.

I have a table where there are unique company names. I have been asked to adda numeric field that will be unique to each company (going in sequence, such as, 1, 2, 3...).

How do I do this since the table already has data?

Thanks in advance.

Russ

 

[DeborahP]

This is how I overcome this problem. I copy the table with all the data and paste the structure only. Add the new field and make sure the type is autonumber. I copied the old table again and then paste using the append data to existing table. It automatically numbers the data you existing. I do my coping and pasting with the right mouse button.

HTH,
Deborah

 

[russi]

THANKS, Deborah.

Worked like a dream!

Russ