Knowledge Base

Works: Copying Database Field Overwrites Destination Field

Article ID: 136703

Article Last Modified on 11/15/2004


APPLIES TO


This article was previously published under Q136703

SUMMARY

When you select an entire database field and paste it into a second field, all of the information in the second field is overwritten. If you just select and copy the information in the first field and not the entire field, you won't overwrite the second field.

MORE INFORMATION

This is true even if the database field that is pasted into has more records than the one that was copied. For example, Field A, with 4 records of data, is selected and copied to the clipboard and then pasted into Field B. Field B receives the data that was copied from Field A, but everything below record 4 is be blank.

Select only the information you want pasted and not the entire field. One easy way to do this is to select the first record of the field you want to copy and then press and hold down the CTRL key and the SHIFT key while you use the DOWN ARROW key to select other records.

Additional query words: w_works 4.00 3.00 3.00a 2.00 2.00a 3.00b 4.00a 4.50 4.50a deletion deleted gone cleared Database Field Pasted Overwritten

Keywords: kbinfo KB136703