Description: If you create a foreign key in Base[1], if just after the creation you edit the table holding the foreign key and go to the index design, you can't see the created foreign key. If you refresh the tables (ie: in Base main menu go to View -> Refresh tables) you can be able to see the created foreign key. [1] You can see how to create a foreign key in: https://bugs.documentfoundation.org/show_bug.cgi?id=167915 Steps to Reproduce: 1. Create a foreign key in Base 2. Try to see the indexes of the table having the foreign key 3. The new foreign key was not found Actual Results: The new foreign key was not found after creation. Expected Results: The new foreign key must be found after creation. Reproducible: Always User Profile Reset: Yes Additional Info: If you refresh the tables (ie: in Base main menu go to View -> Refresh tables) you can be able to see the created foreign key. It is possible to detect the creation of foreign keys and manage this, but I think the right solution would be for Base to refresh the tables after the creation of foreign keys.
I checked that after creating the foreign key my containers broadcast a creation event through a css.container.XContainerListener but nothing changes. I believe, as Mike Kaganski confirmed to me, that Base needs to refresh after creating the relationship. But I'm having trouble finding where the relationships are created in the code... Any help is welcome.