Welcome!

This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!

0

0
Sonia Fernandes
On 11/2/22, 3:14 PM

You could use the pattern Prefix to be Unique. This pattern will create a identifier unique according the Prefix to be unique field.

If you have a sequential number in a child table, you could use the same number according to the father table.

In my example I have a Subject with different topics. Each topic has a number, but i want my topic has a unique number in each subject, so:

Subject 1

  1. Topic 1

  2. Topic 2

  3. Topic 3

Subject 2

  1. Topic 1

  2. Topic 2

  3. Topic 3


In your case, you could apply to the ORDER field the Unique Constraint, as well the CODEMPRE in the Prefix to be unique field.

  • Flag

It works...

Thank you, Sónia :)

Andre Marques
on 11/2/22, 3:37 PM

Keep Informed

About the Community

This platform is for beginners and experts willing to share their Genio knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers. Read Guidelines

Question tools

45 follower(s)

Stats

Asked: 10/29/22, 7:11 PM
Seen: 606 times
Last updated: 11/2/22, 3:14 PM