Can't combine two fields in auto-entry calculation

[eurowonka]

First post here ...

I have a table with three fields:

Record ID: number

Origin: text

Statement: text

I would like the third field to be a concatenation of origin and record id.

I have tried auto-entry using calculated field:

Origin -- works

Record ID -- works

Origin & Record ID -- only Origin shows up

Origin & GetAsText(Record ID) -- only Origin shows

Is there something I am missing?

Thanks in advance!

Sean

[RalphL]

Welcome to the Fourms,

Make Statement a calculated text field = Origin & GetAsText(Record ID).

Or remove the checkmark in front of Do Not replace existing value in the auto enter dialog box.