I built a process in Innovation Studio. I wanted to get all employee records that are associated with another record. When I tried to use "Get record by query" I noticed that it is not possible to choose out of associations between the employee and other records in the expression editor. Also there is no foreign key, which I can understand since the data is fixed in the Foundation.
It would be nice to have access to the association table in the expression editor for Foundation records.