Hi , First of all ,as you said you have to qouery the database for both the numbers and the names using the People.NAMES and the People.NUMBERS , and then you have to map them to some view of your choice , but you must use one view fro each mapping , i think this will solve your problem . best of luck
On Apr 8, 10:44 am, Jiri <[email protected]> wrote: > Hello, > > I am struggling on how to display all the contacts and all their > phonenumbers in one ListView. Because the persons and their phonenumbers > are in two seperate dbase tables I need to do two queries. First one, is > to get the user _ID the second one is lookup the phones tabel and based > on that _ID get the numbers. > Using a Cursor and a ListActivity with a single query is not that > difficult, but what to do in this case where I need to do sub queries. I > tried building my own datasctructure, but that is to slow and to > expensive to do every time. > How do I go about this. The end result would look like this, where each > number is separately click-able. > > ContactName > number > number > number > ContactName > number > number > ContactName > number > etc.. > etc.. > > Thank you. > > Jiri -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en To unsubscribe, reply using "remove me" as the subject.

