- Code: Select all
_SQL_="select v.*, m.* from tblvehicles v left join milesdaystomaint as m on m.VehNumber=v.VehNumber"
I added the SQL code above to the field.ini for the table, tblvehicles. My goal was to add the fields from a view I have defined as a table in conf.ini named milesdaystomaint.
The view works fine as a tab on list view, but I've about given up trying to figure out how to add its fields to tblvehicle's list.
The goal is to remove the milesdaystomaint tab from list view and have the fields show up under Vehicles.
I suspect there is a field naming issue here involving a common field name (the primary key). Any help would be appreciated.