#151 Linked table to 2 instances of the same table

[Anonymous]

Ticket type : Evolution

Description : I have a colour table that stores colours (red, green, etc)

I have a second table that has "foreground colour" row linking as a relationship to the colour table in the "Linked table" column.

The "name of the field" shows the colours table named in the "linked table" column. The cell has a red background indicating that its name can not be edited.

I want a "background colour" row linking to the same colour table. When I add this to the table, the "Name of the field" column now has two names the same, with red backgrounds indicating that they can't be edited.

On attempting to save the table, NSBase warns that the "Name of the field" must have different names.

Would it be possible to allow the same table have relationships on multiple rows?

The work-around at the moment is to either:
1. Create a duplicate table to split foreground and background colours
2. Create an intermediate table that links foreground colour to the colours table

System information : Windows 64 bits / Windows 10 Pro

[Neuts-jl]

Will be fixed in the next version