cocantenate fields as default value

[mapakunk]

O can someone please help me!

I have a table where there are three lookup fields
Region, area, zone
Then a field for a number
How can I join all four fields together into a fifth field called GID?
I know the exp would look like
[Region]&"."&[Area]&"."&[Zone]&"."&[Number]
I can get it to look right on a form, but I cannot tie the value back into the table for some reason.

I've tried setting the default value as an expression (above)

I created a query to join them together but cannot figure out how to dump the query into the field.

 

[Joe4]

Change your query to an Update Query, and put the formula in the "Update To" line of that field.

 

[Mudface]

If you can create a field from other fields, then you don't need to store it in a table, it's just a waste of space. Just base any reports and forms on a query linking your fields together.