Primary Key in a Table ?

mario_trejo
Kilo Contributor

Hi everyone !!

 

How can I set the serial number field as a primary key in the table of hardware assets ??

 

To not enter two equal serial numbers .

 

Thanks.

1 ACCEPTED SOLUTION

Mike Allen
Mega Sage

There is a Unique boolean on the tables now:



Capture.JPG


View solution in original post

3 REPLIES 3

Mike Allen
Mega Sage

There is a Unique boolean on the tables now:



Capture.JPG


So, go to the dictionary of alm_hardware, expose the unique column, and change it to 'Yes' for the serial number column.



Or, go to the dictionary form, add the Unique checkbox, and check it.


THANKS MY FRIEND, YOUR ANSWER   WAS VERY HELPFULLY !