Frequently asked questions - Base

    From The Document Foundation Wiki
    < Faq‎ | Base

    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.

    Available mask codes

    Download an example database