B Bernhard Svavarsson Member Licensed User Longtime User Oct 11, 2014 #1 I have two sqlite tabels which are joined together with key - it is a sort of 'customer order' relationship. Any examples around - been seraching without result regards Benni
I have two sqlite tabels which are joined together with key - it is a sort of 'customer order' relationship. Any examples around - been seraching without result regards Benni
Straker Active Member Licensed User Longtime User Oct 11, 2014 #2 Please, explain the problem with more details... What are you looking for? An SQL statement? Are you using RDC? Upvote 0
Please, explain the problem with more details... What are you looking for? An SQL statement? Are you using RDC?
B Bernhard Svavarsson Member Licensed User Longtime User Oct 12, 2014 #3 I am just looking for example with the feature of showing List of Customers and List of orders. That means two tables two views (customers and orders). If the user clicks on selected customer then the customers order list should show up in another view. This is just a common example seen in other different programming language. Perhabs it is available here in this community - I will look around again. The SQL statement is not a problem here. Thanks for your input Straker. regards Benni Upvote 0
I am just looking for example with the feature of showing List of Customers and List of orders. That means two tables two views (customers and orders). If the user clicks on selected customer then the customers order list should show up in another view. This is just a common example seen in other different programming language. Perhabs it is available here in this community - I will look around again. The SQL statement is not a problem here. Thanks for your input Straker. regards Benni
B Bernhard Svavarsson Member Licensed User Longtime User Oct 12, 2014 #5 No examples there. Regards Benni Upvote 0
klaus Expert Licensed User Longtime User Oct 12, 2014 #6 I would do it in two steps: - Fill the Customer list with one query. - When the user clicks on a customer fill the second list or table with a new query knowing the customer ID. Upvote 0
I would do it in two steps: - Fill the Customer list with one query. - When the user clicks on a customer fill the second list or table with a new query knowing the customer ID.
Beja Expert Licensed User Longtime User Oct 12, 2014 #7 Pseudo code: First list = select * from customer if a customer raw clicked then second list = select * from sales where customer ID = (clicked customer) Upvote 0
Pseudo code: First list = select * from customer if a customer raw clicked then second list = select * from sales where customer ID = (clicked customer)
