Create a unique identifier

[eugz]

Hi All.
Is there a way to index and create a unique identifier using a combination of fields (eg. User# + Provider + Date)?
Thanks.

 

[Bodisathva]

as in a Compound Primary Key? In table design view, highlight the fields you would like to use and press the Primary Key button.