So is the question then how do you get a field like 'Auditor' to be in Trucks? The answer to that then is a different path.
If you have mileage being entered every day you don't have a single auditor - you have potentially many different options to choose from. So you have to do something like find the 'most recent' auditor, or unique list of auditors using summary fields. If you make Trucks table unique by their Asset Number - you can summary data from the most recent mileage entry to then display it in Trucks.
Chayce Duncan | Technical Lead
(720) 739-1406 |
chayceduncan@quandarycg.com Quandary Knowledge Base