Nick Brailsford Posted October 3, 2019 Share Posted October 3, 2019 Hi, I am trying to get a list of all our suppliers out of Supplier Manager but i believe I need to make a join on the tables so i can see contact names. I cant seem to make the join between the two tables i think i need (h_supplier_suppliers and h_supplier_contacts) Could you help please? Thanks Nick Link to comment Share on other sites More sharing options...
AlexTumber Posted October 3, 2019 Share Posted October 3, 2019 @Nick Brailsford yes you can join those two tables. h_supplier_suppliers.h_id = h_supplier_supplier_contacts.h_supplier_id Alex Link to comment Share on other sites More sharing options...
Nick Brailsford Posted October 3, 2019 Author Share Posted October 3, 2019 Thanks @AlexTumber i tried that but it didnt work in the report designer, i have since managed to do it using sql but would like to be able to set this up as a report for others to use. 1 Link to comment Share on other sites More sharing options...
Steven Boardman Posted October 3, 2019 Share Posted October 3, 2019 @Nick Brailsford it should be possible - here is an example of the report on my demo instance - contacts grouped by supplier: I have added the report definition, so if you want to upload on your instance hopefully that should give you a base and you can configure it to suit your needs supplier-contacts.report.txt Hope that helps Steve 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now