Imported data/ Input Mask

[punkspoodle]

Hello there,

In Table A I have a field called Pin Number.
I set an input mask for this field, Pin Number.

Now I have imported a huge number of records into Table B from Excel which also contains Pin Numbers.

I need to link all fields with Pin Numbers, so my question is:

How can I change newly imported data fields to conform to a previous input mask?

many huge thanks,

 

[Len Boorman]

make copy of Table A
Get rid of the pin numbers in table A
Kill the input mask
Select unique list of Pin Numbers from Table B
Paste those into Table A
Make the link with cascade update On
Amend Pin Numbers in Table A
Reset input mask so that all new numbers conform
Append records from Copied table A that do not exist in Table A



L

 

[punkspoodle]

thanks

awesome.
much appreciated!