The 'soft' Labkey-db-level foreign-key linking via the xml file worked, which led me to believe that the 2 tables are properly hooked up on the lower postgres-db level, which was not the case.

After a couple of attempts at linking them on the lower db level, it finally is working properly as expected.