How to display field content in same format?
I want to make sure that a serial number (key field) that starts with PL always show the PL. Right now only when a new record is created the field shows the entire number including the PL (e.g. PL123), but the reports don't. They just show 123. How do I correct this. I can do this probably with a function, but don't know which one and how… Thanks for your help.
Is this field on the reports the same field that you see "when a new record is created"? Is this a field of type number when it should be of type text? (You can use manage database to change the data type of a field). But be aware that if you have this field defined as a field of type number and you change it to text, it will sort differently.