I'm creating a simple application to generate reference numbers for letters to be sent.
Each letter will have a reference and at moment it is working very well, however, the reference must generate an order for each company, and it is working by insertion order, regardless of company, since each company must generate this order separately.
At the moment it looks like this:
It should be like:
My order Field:
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:
In your case, you could apply to the ORDER field the Unique Constraint, as well the CODEMPRE in the Prefix to be unique field.
About the Community
|Asked: 10/29/22, 7:11 PM|
|Seen: 606 times|
|Last updated: 11/2/22, 3:14 PM|