Add that field from the related TO to your layout. Both the Specify fields dialog box and the field picker can be used to do that. You select the TO first from the drop down found in both tools, then select the field for your layout.
Phil, as always, appreciate the fast response and help.
Unfortunately, I've tried that and it doesn't work--it always shows one specific Vendor, regardless of the actual Vendor chosen from the popup menu's Vendor value list.
I think the issue is that the Inventory records reference the same actual table (Companies, but via different TOs, one of which is filtered) for both the Customer and the Vendor. So when an Inventory record is related to both "Customer A" and "Vendor 1" (both originating from the same actual table, but different TOs--one directly to "Companies" and one to the filtered "Inventory_Companies_Vendor" TO), "Customer A" CompanyName is correctly displayed/changes based on the record, but "Vendor 7" (i.e. the wrong one) is always displayed, even if "Vendor 1" is selected from the filtered value list popup. Adding "Inventory_Companies_Vendor:CompanyName" is what is displaying the incorrect CompanyName for the Vendor. The same Vendor's CompanyName is always shown, no matter the record.
Hope that makes sense.
You need this relationship:
Your field names will be different and you may need to add a TO to support this that has a different name than companies, but using the above example as a point of reference, you can add the needed name field from Companies to your inventory layout to show the name of the company for which you selected the ID via your value list.
That worked perfectly. Took me a second to realize what you were saying, but I've got it now!
Just had to add a new TO for Companies and relate Inventory:Vendor to Companies 2:CompanyID and place Companies 2:CompanyName on the Inventory table layout.
Thanks for your help. Makes interpreting these reports much easier.