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

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
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)



Photo of JimLieder

JimLieder

  • 344 Points 250 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,006 Points 50k badge 2x thumb
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?
(Edited)
Photo of JimLieder

JimLieder

  • 344 Points 250 badge 2x thumb
Hi Mark, 

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

Jim
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,006 Points 50k badge 2x thumb
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.