Skip to main content
Question

Getting a field from a great grandparent table

  • December 11, 2023
  • 0 replies
  • 81 views
Forum|alt.badge.img+3

I have the following tables. (Drivers) have many (BOL) have many (BOL Assignments) have many (Inventory Tracking)

I am trying to create a status for a driver based off of the deployment status of the assets that he has on his truck. The deployment status is in the inventory tracking table. The inventory status is updated based off of some check out/in fields. So based off of the statuses of the assets on his/her truck i can know what the drivers status is. If he/she is busy or not busy. Is it possible to get this status from a table that is so distantly related?



------------------------------
Bailey Desormeaux
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+9
    • ChayceDuncan
    • Registered
    • December 11, 2023

    If its a straight line relationship as you describe the summary fields can do it. You can do something like role up into BOL Assignments something like 'Driver Assigned' - then summarize that field into BOL by the same name and then roll it into Drivers to make your status. Your summary field can be the 'Has any records' boolean value and just keep in your grandparent / great grandparent you're just summarizing where that child summary field is checked. 

    Functionally you won't have any issue - you may just want to make the fields in BOL / BOL Assignments non searchable / reportable since that value doesn't make sense in that data context. 



    ------------------------------
    Chayce Duncan
    ------------------------------

    Terms & ConditionsAccessibility statement