select
[Vendor].[VendorID] as [Vendor_VendorID],
[Vendor].[VendorNum] as [Vendor_VendorNum],
[Vendor].[Name] as [Vendor_Name],
[VendPart].[PartNum] as [VendPart_PartNum],
[VendPart].[PartDescription] as [VendPart_PartDescription],
[VendPart].[BaseUnitPrice] as [VendPart_BaseUnitPrice]
from Erp.Vendor as [Vendor]
inner join Erp.VendPart as [VendPart] on
Vendor.Company = VendPart.Company
and Vendor.VendorNum = VendPart.VendorNum
where ( VendPart.BaseUnitPrice is null )
When results appear, is there are way to send the user to the supplier list input screen when they click on the link? I’ve not come across anything like that in my reading.
On the SupplierID, or Supplier Number column, right click the field with the supplier ID you want to open, then go to Open With > Supplier Entry (Or Supplier Maintenance). There is not a good way to make links inside a BAQ. You would have to make a dashboard that is fed values from the BAQ. However, for your purposes, this Open With option may be sufficient.
Good luck!
Nate
Just looked at the results using the Open With. and ideally I need it be able to link back to where the data is missing. so this means i’ve got to make a dashboard. Do you have any ideas / tips on where to start?
I guess the question is… how are your user(s) accessing this query and/or viewing the results?
Are you sending them a PDF SSRS report?
Are they running the BAQ in the query designer directly?
Sounds like you’re not doing a dashboard (yet)… but that’s another way to display the results as @NateS mentioned.
Wait, reading this through again… are you trying to get them to the Supplier PRICE List? That makes more sense.
But again, your “solution” still depends on how you plan on your users accessing this query and results.
PDF report… you can include hyperlinks.
BAQ Query Designer… you can customize the right-click context menu (I would assume on the VendPart.VenPartNum) to include an option to “open with” Supplier Price List.
If in a dashboard… you can kinda do either or both of the above.
While that is how you would add things to the right click menu, unfortunately that only works with single keys. Since you need a vendor AND part number, this won’t be able to handle that. It’s going to take a lot more advanced customization to be able to handle that.