This should be easy for someone. Made a report showing parts and the vendor in their part plant record (we only have one plant). Now the user would like to see the vendor part num. What is the proper way to join this to part plant? I am getting a little confused about the tables. VendPart seems to have one or many records for each part, but the field I need (vendpartnum) is in PartXRefVend which says it is a child table to VendPart… Obviously I would only want one record to return unless of course you could have two active vendor part numbers for one of our parts which doesn’t seem possible.
Anyways, in short, how can I get the vendor part num from part plant using the vendor found on part plant?