How can I pull data into a child table from the parent's other child table?

Thanks Chauncey!! I will give it a try. I hadn't thought of a conditional drop down.

Currently I don't have a Work Orders - Locations relationship set up.

So you are saying to have it set up as one work order to many locations, correct?

So in actuality, a single work order will have a single location for that work order. But I guess that if I needed to generate a new work order for the same location later on, then it would in fact be a On location multi work order relationship.

I will give it a try! Thanks for the tips.