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)
Question
Is there a way to show related Part Numbers when selecting a Part from Inventory?
+5This topic has been closed for replies.
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?
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?
+5Hi Mark,
Would like to see the list of related Part Numbers as an embedded report on the form.
Jim
Would like to see the list of related Part Numbers as an embedded report on the form.
Jim
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.
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.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.