FactorySQL expects each table to have a unique integer index column, and will ask you to choose it when starting a group if the default (“tablename_ndx”) isn’t present.
To set the index column manually, click on the “options” link above Table Name on the group’s action tab, and select “Edit Column Assignments”.
In FactorySQL these assignments are stored internally, linked to the table name & connection. This has been modified in Ignition, where it is now just a property of the group.
Hope this helps,