Primary Key Help

[Guest]

I have a .txt file that is imported into my db each month, which contains the
following fields:

Desk RcdLoc

Each record represents a person. Each person has either a Desk or RcdLoc
code assinged to them. A person can sometimes have both.

I really need to have a primary key in this table. I know I can't do a
multiple primary key because most of the time either Desk or RcdLoc is null.

I know that if I were creating these records from a form or in the table, an
autonumber field could be the primary key, but will and how would an
Autonumber field work with the imported .txt file?

Thanks for you help

 

[Guest]

If you set the Default to "-" then it will not be null.

 

[Joseph Meehan]

I have a .txt file that is imported into my db each month, which
contains the following fields:

Desk RcdLoc

Each record represents a person. Each person has either a Desk or
RcdLoc code assinged to them. A person can sometimes have both.

I really need to have a primary key in this table. I know I can't do
a multiple primary key because most of the time either Desk or RcdLoc
is null.

I know that if I were creating these records from a form or in the
table, an autonumber field could be the primary key, but will and how
would an Autonumber field work with the imported .txt file?

Thanks for you help

Will you not want the person's ID of some sort (name number etc.) for
each one? If so that could be your primary key.

BTW Why do you need a primary key???

 

[Guest]

I created a primary key by adding an autonumber field to the Main table,
importing the New table then appending the Main table with records from New
table. This works great. Thanks