BaileyDesormeau
2 years agoQrew Member
Getting a field from a great grandparent table
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
------------------------------