Skip to main content
Question

Creating custom cross-table unique values


tim_bkr
Participant
Forum|alt.badge.img+5

Hi,

I'm creating objects in 5 different tables and I have a requirement for the object's IDs to be unique accross all 5 tables. I also need to set the starting ID value with a UserParameter

Suppose I had 3 features created in each table.

My objective would be :

Ids 1 to 3 in table A

Ids 4 to 6 in table B

Ids 7 to 9 in table C

...

Would anyone have a suggestion for the best way to do this?

I've tried with counters and feature holders but I haven't been successful. Strangely, I get something like

table A : 1,2,3

table B : 1,2,3

table C : 4,5,6

although it seems to me I'm doing the exact same thing between table A and B and between table B and C...

 

Cheers !

2 replies

ebygomm
Influencer
Forum|alt.badge.img+38
  • Influencer
  • October 22, 2021

As long as your counters have the same name and the scope is set to global you shouldn't have to do anything more


tim_bkr
Participant
Forum|alt.badge.img+5
  • Author
  • Participant
  • October 22, 2021

I see. So you have to set "Count start" to 0 although you expect it to continue from where the previous counter (with same Counter name and Global Count Scope) finished. That's what I've done now and it works.

Thanks ebygomm.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings