Skip to main content
Question

Look up field won't populate

  • May 6, 2019
  • 0 replies
  • 42 views
Forum|alt.badge.img+7
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 the value field. The problem is I get nothing in the look up field. Why would this be happening? Truck mileage is updated through Google drive.
    This topic has been closed for replies.

    If your mileage is being brought in from Drive - are you sure that it is being properly associated with 'Related Truck'? Sounds like they might not be related correctly right now. Another avenue to check is to make sure the field types are the same. Is auditor a user field at the parent level and then also a lookup-user in mileage?

    Chayce Duncan | Technical Lead
    (720) 739-1406 | chayceduncan@quandarycg.com
    Quandary Knowledge Base
    Forum|alt.badge.img+7
    • StevenPearson
    • Author
    • Registered
    • May 6, 2019
    The parent table is Truck Mileage, populated by Google drive, key field is asset number. Child table is Trucks, reference field is related truck, they are both text fields.
    Can you elaborate more on why it's set up that way? I would imagine your architecture being the opposite -  where Trucks would have many mileage records. Mileage doesn't seem like a natural parent record to a Truck. Is the data in google drive a recurring entry on a trucks mileage? What specifically is being entered in Drive? 

    Chayce Duncan | Technical Lead
    (720) 739-1406 | chayceduncan@quandarycg.com
    Quandary Knowledge Base
    Forum|alt.badge.img+7
    • StevenPearson
    • Author
    • Registered
    • May 8, 2019
    You're absolutely right about the relationship. Trucks "should" be the parent table. But when that is the case, I have no option to choose a look up field in the mileage table when setting up the parameters for the field. The only option for a look up field are those where the look up field is part of the child table in the relationship. The information in the mileage table includes asset/truck number, auditor, mileage, and others and is updated via Google drive every day.
    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
    Terms & ConditionsAccessibility statement