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

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?

Hi Mark, 

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.