Good day have all hope I can help with this problem. I have 3 tables which are Price, Products and Customers List, Price List is related to products and customers, to add a price list I have to assign a customer and a product with their respective prices, the question is that to add a new sale I must first select the client using a combobox and based on the selected client should show me the products that customer has in the price list for example: List1 = customer1, product 1 List2 = customer1, product2
If I select the client1 in the product combox, it should show the product1 and the product2 and in this way with the other registries I hope you can help me to know how to link the comboboxes I am using java and SQL Server in advance thanks.