Join strings in Query

[matty ratafairy]

I have a "Customer" form to input customer details. The e-mail address is in
two parts: "e-name" and "Provider". I have a Provider table the field in my
table shows IDProvider"1" Provider"hotmail.com" and "2" "yahoo.es" etc. This
is related to IDCustomer in a 1 to many relationship.

I want to join them so, I made a "Full e-mail" query expr1:
[e-name]&"@"&[Provider]

This returns "matty@1" when I'm expecting "(e-mail address removed)"

If I do simple query to return Col1 e-name and col2 Provider it gives col1
"Matty" and col2 "hotmail.com"

What am I missing? (Except a brain)

 

[matty ratafairy]

Its ok I found a way - I removed the Primary key field and made the
"Supplier" the primary key.