Streets Table:
ID Street
1 Alpha
2 Beta
3 Gamma
4 Delta

Addresses Table:
ID Number Street2
1 1122 Alpha
2 1234 Beta
3 1245 Beta
4 7854 Delta
5 5980 Alpha
6 5765 Gamma
...1000

I want to combine the addresses into one field, but everytime I run a query that comes up in Google Searches, I end up with:

New Addresses Table:
ID Number Street2 Combined
1 1122 Alpha 1122 1
2 1234 Beta 1234 2
3 1245 Beta 1245 2
4 7854 Delta 7854 4
5 5980 Alpha 5980 1
6 5765 Gamma 5765 3
...1000

Obviously my reference is picking up the ID from the Streets Table, how to I select the value of the Addresses Table?

The fact that 50 members have read your post and no one has responded is probably due to the fact that, like myself, no one has any idea what you're trying to do! I think you need to explain your statement
in greater, plain-English, detail, in order for us to help you.

Linq ;0)>