Hi,

Your information indicates you need to redesign your structure of tables and use join query, and you aslo mentioned how to redesign the tables. Therefore, the key point how to use join query to retrieve the records, please check this reference about join query:

http://msdn.microsoft.com/en-us/library/ms191517.aspx

By the way, if you can post your problem to this:

http://forums.asp.net/1226.aspx/1?SQL+Server+SQL+Server+Express+and+SQL+Compact+Edition

You will recieve more professional and exact idea for your issue.