Hi,
On the Tables screen in PHPRunner there is a difference between Views and Tables. I am referring to PHPRunner Views, not Database views. For a View, I see all of the fields as defined by the View SQL statement on the following Query screen, but for a Table I only see the fields in that database table, even if I have supplemented the table fields with joins in the SQL statement on the following Query screen. This means I am able to create a Master-Child relationship off of a joined field for the View, but not for the Table even though the SQL queries are identical. Is there some trick to this?
Thanks!