Discussions

Expand all | Collapse all

Need a Reverse lookup with a text Key Field

  • 1.  Need a Reverse lookup with a text Key Field

    Posted 06-25-2018 14:53

    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



  • 2.  RE: Need a Reverse lookup with a text Key Field

    Posted 07-13-2018 21:16
    What's the key field of the Work Order Locations table?