[SA 7.1.166 Pro] - SQLite One way relationships

[SA 7.1.166 Pro] - SQLite One way relationships

It seems that the relationships between tables are detected in one way only.
I've got the following relationships between tables activities, assignments and activity_status_types:

When I try building table joins between activities and assignments starting with activities table, the popup does not show the relationship:

Manually selecting the table for join indicates that the relationship recognized is based on name matching instead of the foreign key:

But when I try it starting with assignments table, it works:

Thank you very much for reporting this issue. I will let the development team know and ask them to look into that.

Any progress on this one?

This is a limitation of SQLite, the PRAGMA foreign_key_list() statement returns referential integrity constraints for a table, but not constraints referencing that table, basically it works in one direction only. We have implemented a workaround, but it's not in a publicly available build yet.