In my PHPr project I'm using an MSSQL view to pull in some external data.
It's listed in the tables list, and I've added all the links in on the "Datasource tables" screen such that I should be able to display child records etc. However, once the project is built this functionality is not there. (eg. I don't get a pop up, and I can't click into the child records).
One thing I noticed is that despite setting my 'ID' field as the Selected Key Column on the 'Choose Pages' screen the little key icon never appears on the Datasource Tables screen or the Tables List.
Is there something else I need to do to make the child records etc work?
PS. I'm using a view from MSSQL server, not the built-in php runner 'views' tool.
Thanks!