Discussions

Expand all | Collapse all

Is there a way to show related Part Numbers when selecting a Part from Inventory?

  • 1.  Is there a way to show related Part Numbers when selecting a Part from Inventory?

    Posted 06-05-2018 19:09
    I have an Inventory app that consists of a Master List of Costs (parent) and Inventory (child) that are related by Part Number.  When a Part Number is chosen from Inventory, we want to see a list of related Part Numbers from the Master List of Costs table that are typically installed at the same time.

    Any suggestions on how to set this up?

    The related Part Numbers will be manually entered, for example:
    Part # 1 - DC Drive (the main component)
    Part # 2 - Fuses for DC Drive (related item for Part # 1)
    Part # 3 - Keypad for DC Drive (related item for Part # 1)





  • 2.  RE: Is there a way to show related Part Numbers when selecting a Part from Inventory?

    Posted 06-05-2018 19:57
    Can you explain what you mean by


    we want to see a list of related Part Numbers from the Master List of Costs table that are typically installed at the same time.


    See where,? ... on a drop down list or as an embedded report on the form? Or some other meaning?


  • 3.  RE: Is there a way to show related Part Numbers when selecting a Part from Inventory?

    Posted 06-05-2018 22:39
    Hi Mark, 

    Would like to see the list of related Part Numbers as an embedded report on the form.

    Jim


  • 4.  RE: Is there a way to show related Part Numbers when selecting a Part from Inventory?

    Posted 06-05-2018 23:31
    Well, you can make a report link type field and it will run any report you want.

    One limitation though is that the record has to be saved before the report will update.

    A report link field does not need to be part of a relationship. So you just create a report link field and specify on the left side of the configuration what the field is that you were matching too. So in your case it would seem to be related master part.

    And then on the right side of the configuration you navigate back to your app and then to the trial table and locate the matching field which would be related master part.

    Then like any report link field you specify that the record should be listed directly on the form and decide what you report you want to use to display them.

    The main Magic is that the realization that you do not need to have a relationship in order to have a report link field.