The default FANum in the FAsset table is only 20 characters, and this length is not enough for our Customer. We want to add the length for the FANum Column. I read on some posts before that we can add the length directly from the database but is not recommended to change the system table. So the question is what is the best practice to change the length as we don’t see another option.
Yes, I wouldn’t change the database.
I’m not sure this would work in your case but…
to get more characters from other tables I’ve used UDCodeTypes/Codes (or UD Table.Fields)
So after setting up a UDCodeType and UD Codes
I’ve added a combobox the the entry form that will list UDCode descriptions
Then I only need to store the UDCode in my field
Maybe UD field is the best solution.
HI, @Davie.Qin and @bordway thanks for your answer. but yeah I wonder because the field I want to change is Key field can I really change that? because the key field is used in the Lookup field right.
I’m not too familiar with FAsset but guessing not, the key will remain the key.
TBD if you can display the longer values you want by linking to the key to something else… and how complicated it would get?