Auto fill in fields in table

[Cindy_B]

I searched the archive but could not find this specific topic...
There is a table and data entry is done straight into the table. (No form is used or wanted.) Date is automatically filled in with current date, operator types in an amount field and then there is a "batch" field. There may be several amounts entered with the same batch, then the batch number changes. What they need is for the batch field to automatically fill with the previous batch number so they can just enter through that field, then change the batch number when the need arises. Is this possible. Maybe I'm making it too complicated but I am at a dead end here.
Thanks,
Cindy

 

[FoFa]

OK, Why not use a tabular form that pretty much looks like a table, but gives you the ability to control your fields some what. Is thaere not an autofill from last record functin? You could always put an invisible field on the form that your batch number defaults to and gets updated when the batch number is changed. That would also do what you want. But I don't know of a way without using a form.