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.
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.
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.
André Arnaud de Cal...
292,162
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156