Primary Key Identifier

[SKV]

is there a way that let system selects the field combination to generate Primary key for that data base.

I have 50-60 fields and each has a repeating value at some point. So I want the system to check a combination of fields which can give me primary key for that data base.

 

[james_lankford]

just insert an autonumber field into the table and have it be the primary key

 

[SKV]

I can use Auto-number as I get a datapull every month in which records may be repeated.

IF I use the auto-number than during appending I will get duplicate records.

just insert an autonumber field into the table and have it be the primary key

 

[SydneyGeek]

If you want you can create a compound key.
In the table design control-click the fields that you want to include in the key, then click the Primary Key icon and save the table. If it can't save you already have duplicates, and will need to correct that problem before creating the key.

Denis

 

[SKV]

Yeh that is a option but I want the system to select the minimum required fields to make a primary key.

If you want you can create a compound key.
In the table design control-click the fields that you want to include in the key, then click the Primary Key icon and save the table. If it can't save you already have duplicates, and will need to correct that problem before creating the key.

Denis

 

[SydneyGeek]

You'll probably need to write some code that picks your fields (say) four at a time, concatenates them, groups and looks for duplicates. That's a huge number of permutations.
Why don't you pick the 4 most likely, concatenate and group them, and if you find any duplicates keep adding one field at a time until you get a unique set. You can then use this combo as your key fields.

Denis