Depends on what you need exactly.
You can use calculation elements in your third list doing mySql queries
https://fabrikar.com/forums/index.php?wiki/calculation-element/
https://fabrikar.com/forums/index.php?wiki/php-common-tasks/&redirect=common-php-tasks
You can create a MySQL view in your DB and link a Fabrik list to this view.
Hi, there are questions with running php code in the form of a list, I created a list with two standard fields id and date, add a third with the field class, insert the code in the default field, go to the page of the sheet, but not what data is not uploaded, what am I doing wrong? Please tell me?
// Get a db connection.
$myDb = JFactory::getDbo();
// Create a new query object.
$myQuery = $myDb->getQuery(true);
$myQuery
->select(array('id', 'name'))
->from('sbrh2_datebase')
->where('id = ' . $myDb->quote('value'));
// Assign the query to the db
$myDb->setQuery($myQuery);
// Load the results as an array of objects.
$rows = $myDb->loadObjectList();
$list = array();
foreach ($rows as $row)
{
$list[] = "<li>" . $row->id . " " . $row->name . "</li>";
}
return "<ol>" . implode($list) . "</ol>";