Selecting primary key when none are available

[kaygirl]

I am creating a new database and am unsure which is the best method for creating a primary key from the fields I have availble. From table 1 I have firstname, surname, jobtitle. Can I use another field from another table (table 2)'organisation'. (Table 2 uses the autonumber).

Note. I do not want to use the autonumber in this table (Table 1) as it is not representative of the data contained within it.

Thanks for your assistance

 

[rry2k]

I'm not sure why you don't want to use autonum again.
The primary key needs to be unique so first name, surname or jobtitle won't work. I'm not sure if you can use a field from another table as a primary key. You can add it as a field though by setting it as a lookup field.

Russ

 

[binky]

Maybe creating a date field setup to default to the current date/time could be used?

HTH
Ken :