Need a Reverse lookup with a text Key Field

I need to create a report from the attached table relationship

with the following fields

From Work Order Table (Key Work Order# - Text)
Work Order Number

From Location Table (Key Tag ID# - Text)
First Address

From Task Table (Key Record ID# - Numeric)
First task where Task Name = "Add to Replicon"
Start Date
End Date
Status

Report should reside in the tasks table
Start Date, End Date and Status should be editable

I can get everything but the address how can I pass the first address for a work order
from a Many to Many relationship with a Text Key