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

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?

have you tried to use Alias?

Sorry, but what’s Alias?

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

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

have YOU tried to use Alias? :smile:

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