Any problems copying one existing record to another existing record?

[tmb]

Are there any problems that will be created if I...
....in table view...
....select one record's contents and then copy that over another existing
record?

It seems to work in a test data base... but I haven't tried it on the real
one yet.

thanks for any help.

 

[Joseph Meehan]

Are there any problems that will be created if I...
...in table view...
...select one record's contents and then copy that over another
existing record?

It seems to work in a test data base... but I haven't tried it on the
real one yet.

thanks for any help.

While there are situations (like a filed not being updateable) where you
could run into problems but most of the time it should work fine. Make sure
they are like data types.

 

[Mike Schlosser]

I agree.


EXCEPT - for an auto number field.
You cannot overwrite an autonumber field.
And if you decide to move the records to a history table, the autonumber
field in history table should be set to Long Int. - And make sure the field
lengths
of the others are the same, so you don't loose data.


By the way, why would you want to duplicate an entire record in the same
table ?

Mike Schlosser