Several ways to handle this. Unless you have a huge amount of data, the cleanest thing would be to merge the data on the server. The RPC protocols are very fast. You did not mention which protocol you are using.
If you want to do it in two queries, then yes, include an id in the detail node, use an e4x expression to get the related data on click. More detail might help us be more specific. Tracy ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of steve Sent: Monday, September 10, 2007 4:56 PM To: [email protected] Subject: [flexcoders] Merging xml files? relational database design question Hi, I've got two mysql tables representing a student db, one table student info with student id, picture and year, another table student_detail with student id, address, SSN, etc. When I first load the application I read in a student_info xml file and show the students in a TileList component. I then want to read in the student_detail xml file in the background and then when I click on the student Id, quickly retrieve and show the student_detail. Is there a way to index the student_detail by student_id, or what's the best way to retrieve student_detail when I know the student_id? thanks,
