I need your help to display records from multiple tables (tbl_users, tbl_dependants), I want to display user information in one row and user dependants in a column after ending user information, the two tables are related with (user_id). When the first user recordSet finishs displaying all user information + his dependants, it goes to the next line and print another user details,,, and so on.
I searched the entire forum for a help but I couldn't find.
Best Regards, [ January 05, 2006: Message edited by: Bear Bibeault ]
Hope that helps. They are called joins and you should read up on them.
You could also query all the names from the 1st table, loop through them and on each loop query for the dependents associated with that users name. That's not a very efficient way to do it, however. [ January 05, 2006: Message edited by: Matt Gatten ]