Is there a way that I can duplicate a field from every record to a new field so I can alter it?
You can duplicate a record, with all its fields (command-d), so that you can modify the ones you need to - useful when some of the fields don't have to be changed.
I need to copy the same field for every record in the database, not just the field from one record.
Or you can set a field to auto-populate - perhaps that's nearer to what you want?
Stephen Bunker wrote:
I need to copy the same field for every record in the database, not just the field from one record.
if you make a new layout. which includes only the field in question, does that do what you want? You can then select all and copy.
Here is an example:
Record 1 field A has XYZ
Record 2 field A has QRT
Record 3 field A has ZZT
etc. for 31 records
I want to have this:
Record 1 field G to have XYZ
Record 2 field G to have QRT
Record 3 field G to have ZZT
etc. for 31 records
Field G (called 'Field 2' in this example) should be a calculation field as shown here:
AW Database: duplicating a field to every record.
