Juntion table with a lot of different numbers as PK

[jaryszek]

Hi,

my TEST model looks like:



And now in t_topotojunction table in TopoToJuntion_ID PK i have numbers not from 1 to 5 but 1, 125, 4, 6, 55

When i created the model i inputed different data into tables and that is why i have different numbers as PK.

And i am thinking it is possible to reset it (and all referencing tables like t_junction, t_cpuoffer) and have still good relationships?
And if it is necessary or not?

Best,


Jacek

[ssanfu]

<snip>And now in t_topotojunction table in TopoToJuntion_ID PK i have numbers not from 1 to 5 but 1, 125, 4, 6, 55

Don't take this wrong, but so what?
Is "TopoToJuntion_ID" an Autonumber type field?
Does it really matter what the value of the PK field is? If it matters, why is the field an autonumber type field?

AutoNumber
----------------
Purpose: Use an AutoNumber field to provide a unique value that serves no other purpose than to make each record unique. The most common use for an AutoNumber field is as a primary key,

Autonumbers--What they are NOT and What They Are

[jaryszek]

Hi ssanfu!

thank you !
Hmm it doesnt matter and yes it is autonumber.

You have right!
Best
Jacek