Populating a primary key with 2 fields

PlasticsGuy

Registered User.
Local time
Today, 18:42
Joined
Jun 24, 2004
Messages
26
I am looking to create a cancatinated string to populate a primary key field in a table. It is going to be created while in a form from 2 of the fields in the form. They are called [EID] and [Pay Period]. I want to do this so that there are no dupilcate entries. Can someone here help me with this? :confused:
 
Ok I just got it. :o All you have to do is designate the two fields I wanted to use to create a key as dual primary keys. :cool:
 
Glad you got if figured out. What you were looking for is called a concatenated key.
 

Users who are viewing this thread

Back
Top Bottom