Auto derive table field from two others?

[Pete Langbridge]

Hi - I'm new to Access (old experience with DataEASE RDB) - I'm having an incredible struggle - with something I thought would be SO simple.

I have two text fields - having looked up one, and entered the second, I need field three to be a concatenation of the first two. EASY ?

I've not managed to define the field in the table to do this (this is where I would prefer to perform it). I was really expecting something like:
concatenate [field1],[field2]

I have managed to define a form that shows the value on the screen - but it does not update the field (it's a control - it appears to display only)

Please - is there a simple way to achieve this at table level - the new field is needed for a key.

TIA

[Rabbit]

You can't do this at the table level. But if you need it for a key then use a multi-field key.

[Pete Langbridge]

You can't do this at the table level. But if you need it for a key then use a multi-field key.

Thanks Rabbit - moving on well now!

[Rabbit]

Good luck.