>here's an 'Update model from database' option which will allow you to add additional tables - but also refreshes existing tables by, for example, pulling in any additional fields. But this isn't fool proof either - sometimes 'subtle' (can't think of a better word) changes to the database aren't included.
>>
>>If you're just starting with L2S you might consider going straight to EF instead? At it's simplest it's very similar to L2S - but you've got the additional functionality when you need it.....
>
>
>Don't you just hate it when.
>
>I thought I'd have another look at this.
>
>I deleted the dbml and re added it and the foreign key relationship appeared no problem.

:-}
Usually happens to me when I make changes in SQL but forget to actually write them away (e.g saving a diagram). But I don't think that could have been your problem.....