Android Question Master - Detail example

[Bernhard Svavarsson]

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]

Please, explain the problem with more details... What are you looking for? An SQL statement? Are you using RDC?

 

[Bernhard Svavarsson]

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

 

[Beja]

Check Klaus signature

 

[Bernhard Svavarsson]

No examples there.

Regards

Benni

 

[klaus]

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]

Pseudo code:

First list = select * from customer

if a customer raw clicked then second list = select * from sales where customer ID = (clicked customer)