Faq/Base/129

From The Document Foundation Wiki
< Faq‎ | Base
Jump to: navigation, search

Template:TopMenu/en Template:Menu/en Template:Menu.Documentation/en Template:Menu.FAQ/en

Other languages:
dansk • ‎Deutsch • ‎English • ‎français

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