I made a component with this awesome tool.
In this component i have a list of items pulled from the Database, this list is build from joining two tables. (items.php)
I have made all the items in the list clickable so you can see more info about each list item individually; (item.php)
I made the SQL statement for thejoin in the model for items.php.
If i look at the generated models file for item.php; i can't see any sql statement, i'm guessing it has something to do with the model for items.php ?, i tried messing with the items.xml inside the forms folder, but that had no affect, how do i pass the joined info from items.php to item.php ?
but in the edit view (item.php), i can only see data from one of the two joined tables, the joined data does not seem to be forwarded to the edit view.
Does anybody know how to assist me ?