This is a script step, on the dropdown menu, and has a keyboard shortcut of Ctrl-D.
Is this what you are looking for?
Note that this will duplicate all fields, but will still put in a unique autoenter serial if there is one on this table. Is this an issue?
is it always the same 3 fields that need replicated from the previous record?
And is the replication of the field data performed every time a new record is created or only when the new record matches certain criteria from the previous record?
Note that this will duplicate all fields, including an autoenter serial.
the autoenter serial will be the lone not duplicate field !
When I mocked it up in my "goofing around" Dbase, I didn't notice that the ID field I was looking at was from a related table.
Thanks for the correction. I have edited my post above.
Thanks to all the replies,
We enter around 15 fields of data to approx 20 - 30 records in one go where 3 of these fields are diferent or have different data.
Didnt know about CTRL-D this works fine as it reverts the cursor to the 1st field so i can layout the 3 fields to be fields 1,2,3
That is probably the easiest workaround.
Many thanks for all the replies and info.
Another trick that copies data from a previous record's field is to press ctrl-' while your cursor is in that field. That trick can be useful when there are just one or two fields that contain identical data in the previous record.
Ctrl- is another i hadn't found yet.. Yes that would be usefull with some of our procedures.
The CTRL d works fine when we are adding records with 2 or 3 fields that are different.
many thanks to all replies