Frequently asked questions - Base
From The Document Foundation Wiki
How do I manage a composite key (string + numbers)?
For example, you could create a primary key composed of five characters followed by four figures.
At the table level, create a field of type VARCHAR, length 9, as a primary key.
- On the creation form use the control "Masked field" with the properties:
- Input mask: AAAAANNNN
- Validate input: Yes
With this setup, only valid characters are accepted.