I made a mistake in my initial question. The relationship betwen BOL and Inventory Tracking, so the great grandparent and the grand parent. Each (Inventory tracking) has many BOL Assignments. So i cant do the summary all the way down. The relationships are this:
Each Inventory Tracking which is an asset mission assignment has many BOL assignments. Then Each BOL has many BOL Assignments, Then Each driver has many BOLs. Maybe the picture below will help? I was trying to use an API that chatgpt created haha but it wasnt working. It was trying to get the record from the start of the relationship and bring it down through the tables somehow.
Same process would apply in practice, honestly a little easier. You would add a lookup field from Inventory Tracking into BOL Assignments if you don't already have it for the Deployment status of the Inventory Tracking.
Then in the relationship between BOL and BOL assignments - summary field of any records where Deployment Status (lookup field) is whatever status(s) you consider deployed.
Then in the relationship between Driver and BOL - summary field of any records where the previously created summary field is checked.
Thank you very much for your help! I think this is going to do it now that I read your idea, that was my kind of my initial strategy but for some reason I did not think it would work!
