How to look up formatted AutoNumbers?

[Fekla]

Good evening,

I am a little confused. I have one table with the Autonumber field and another table with a field that looks it up.

Tha problem is that I am using a Format for my Autonumber, e.g.
"O0045". And the field with the foreign key refuses to accept it! It needs a number to be entered, i.e. 45, and then it can format it. So on the whole, the LookUp Feature does not work, because it suggests FormattedAutonumbers, which do not fit in (obviously the foreign key accepts numbers only).

Is there a solution? Thank you in advance.

 

[Moniker]

Add the record as "45" and then change the formatting on the foreign key to be the same as the format on the primary key. There's no way to make an autonumber contain a letter like you've shown, so that's how it's being done in the first place. It stores "45" but shows "O0045".

 

[Fekla]

I see. But in this case I do not benefit from the Autolookup feature.

Thank you anyway.