Autonumber?

[RichGags]

Hi,

Is it possible, when adding a record via a form to table1,
to have that form obtain the autonumber from table2, put that number in a plain non-indexed Integer field and then increase table2's autonumber by 1?

Thanks