Cobine two columns to display information in a third column as a Unique Identifier.

[usmananyc]

Hello Everyone,

Im in need of some assistance. So i have a access database with a main field that we can call vendor # (LIFNR) and another called Company code (BUKRS). There are multiple company codes under a single vendor #. Example:

LIFNR	BUKRS
0000010535	1010
0000010535	5060
0000010535	5610
0000010536	1010
0000010536	5060
0000010536	5610

What i am trying to do is create a 3rd column where i can have a unique row for each of these fields without it repeating. There is no unique identifier in this table and that is what i am trying to achieve. Please help.

Thanks in advance!

[June7]

Set the two fields as a compound index to prevent duplicate pairs.

Do you want to save these values as foreign key in related tables?

Why don't you use autonumber field as PK and save as FK in related tables?

[usmananyc]

I simply used the concatenate function to combine the text in both columns into a 3rd column. Very simple. Thanks for your help June7.

[June7]

Yes, concatenation expression does that but why do you need to? Setting compound index on the two fields will prevent duplicate pairs. I've never used Calculated type field in table. Did you set it as Index No Duplicates?