Look up field won't populate
I have 2 tables, Trucks and Truck Mileage. Truck Mileage has a field called auditor that I want to pull in to the trucks via a lookup. Using related truck as reference and truck mileage: auditor as th...
Forum Discussion
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
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