Unable to get the InnerRecord for the specified column...

Problem

You get this error when attempting to run your application:

Unable to get the InnerRecord for the specified column because the named query is invalid.

This error occurs when a custom query joining multiple tables does not have the proper virtual foreign key relationships defined. When creating a custom query, every virtual primary key should set a virtual foreign key to the primary key in the original, underlying table used in the custom query.

Solution

Set the appropriate virtual foreign key and virtual primary key relationships in Iron Speed Designer (Databases, New Virtual Primary Key…; Databases, New Virtual Foreign Key…).