Discussions

Expand all | Collapse all

Need multiple fields to lookup from a child to a parent record

  • 1.  Need multiple fields to lookup from a child to a parent record

    Bronze
    Contributor
    Posted 05-02-2018 00:55
    I cannot begin to stress how much trouble I have with reverse lookups....so with that being said

    I have a Projects Estimate table and an Equipment Descriptions table that has type, description, price etc.

    I am building a simple mobile app that our sales team will be able to stand in front of the customer, plug in some data and get an estimate. What I need is about 10-15 lookups to pull the part description and unit price of each item so that I can multiply those by a quantity field for each item.

    I have tried several times to pull these fields in but they are just blank

    • I created the one to many Project Estimates have many Equipment Descriptions
    • I created the summary field of the max of the equipment table record ID
    • I created the many to one Equipment to Project Estimates and used the max and the related equipment.
    • I created another summary to look at the total of the unit price and a filter for the part description....nothing!
    Any help is greatly appreciated


  • 2.  RE: Need multiple fields to lookup from a child to a parent record

    Top
    Contributor
    Posted 05-03-2018 04:14
    It might just be me, but it seems like you might need another table.  Basically a joined table that would be your "Project Estimate Line Items"

    Then when you add a line item, you pick the product (all the lookups come with it, Price), then they entry the Qty.  And a simple formula gives you the cost per line item.  Then a summary for the total estimate cost.

    Not sure the reverse relationship is needed.



    Matthew Neil - Product Specialistmneil@mcftech.com Phone: 440-201-6050 ext. 476" width="300px">