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 using the Field Properties dialog in your application’s Databases folder in the Iron Speed Designer Application Explorer.