Need a Reverse lookup with a text Key Field

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • In Progress

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

Photo of Eric Turrentine

Eric Turrentine

  • 490 Points 250 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
What's the key field of the Work Order Locations table?