Automatic field fill in base

[effediqu]

I have a form in base with several fields connected to a table. I wish the form to have a special field not blank, but pre-filled with the value of previous record in table. I.e: I fill all fields in the form to complete the first record of the table. Afterwards, when the form show me the second record ready to be filled, all fields should be blank except one of these I wish to be already filled with the value of previous record. Thanks all for any help…

Federico Quadri

[frofa]

I think this can be done either with an SQL TRIGGER or a MACRO. Using a trigger will probably require a MySQL or HSQLDB v2 backend. (Triggers are not possible with the default HSQLDB v1.8). Here is a posting on record-cloning using a macro. This posting has some information about creating a TRIGGER to do the job (under HSQLDB v2.x only).