How to change a field in SysRecordInfo?

(0) Share

Report

Posted on by Shooowtek

843

Hello,

I have a custom table with primary key e.g: CarID. I would like it to be possible to rename the CarID in the SysRecordInfo dialog. Currently the RecId can be renamed.
Can anyone suggest how to do this?

Thanks.

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Martin Dráb 238,272 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The recommended design is using the surrogate key (RecId) as the primary key and CarsID as another (alternate) unique key. All references should use the primary key: RecId. If you follow this design, changing the value of CarsID is trivial, because the primary key remains the same and you don't have to update any other table.

Was this reply helpful? Yes No