How does one setup a parent relationship to the same table with TOPSPEED?

questions
1

For a specific table I would love to use a parent relationship to the same table, this way I can prevent duplication of data (else I would need to repeat the parent data for each child, or use it without a relationship) - but when trying to set this up, I cannot select the same table in the 1:MANY or MANY:1 options, it disappears from the dropdown - is this just not supported? Or is there a way to set this up?

2

have you tried to use Alias?

3

Sorry, but what’s Alias?

4

image
image600×501 18.9 KB

An alias creates a second reference for a table without duplicating the file on disk.

5

And you can create a relationship between a table and it’s alias?

6

have YOU tried to use Alias? :smile:

7

Just did - thanks for the help - was busy looking why a PUT gives me a Creates duplicate key error…