Unique Value of three variables combined

[SFGiants21256]

Hello,

I'm trying to create a unique ID for a database and am running into a roadblock. I have three variables: group, unit and accountability number. Each of the variables can be repeated but they cannot be repeated when all put together.

Here is an example:

Groups: Alpha, Bravo, Charlie
Unit: Delta, Echo, Foxtrot
Accountability Number: 1,2,3,4,5

AlphaDelta1
AlphaDelta2
AlphaDelta3
AlphaEcho1
AlphaEcho2
AlphaEcho4
CharlieFoxtrot1
CharlieFoxtrot2
CharlieFoxtrot3
CharlieDelta1
CharlieDelta2
CharlieDelta3
CharlieDelta4
CharlieDelta5
AlphaEcho4 (this is repeated and should be rejected)




You can see from the example all the individual groups, units, and accountability numbers can be repeated but not when combined.

If anyone can provide some assistance it would be greatly appreciated.

[ranman256]

In your table, create an update query to fill in the [fey] field

update table set [key] = [group] & [unit] & [accountability]
run this query.

[orange]

Create a primary key (by definition it is unique)

of the combination Groups,Unit and accountability. No NULLS allowed.