pimech

Unique combination of two fields?

Discussion created by pimech on Sep 2, 2016
Latest reply on Sep 2, 2016 by philmodjunk

Hi, i'm a newbie user.

I have a table of two fields, "P/N" and "Rev.".

I want that cannot exist two records with same P/N AND Rev.

 

I was thinking to solve creating a third field as auto-calculation, P/N&Rev concatenated and set as unique this field.

 

Is this the best solution?

Are there other ways?

 

Thanks

Outcomes