Hi, You need to create a relationship between the two tables first:

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

www.youtube.com/watch?v=xL7h4VQhXFY

Then update your datacontext. (you can remove and add the tables again)

After then, you can use the solution I mentioned.