I am trying to put together a table and want to have an auto number that
counts the recods and puts the next number in for a new record. Need a good
method to do this and to have it automatically carried down when a new record
is created.

I also have a formula that calculates interest on a principle amount.
Neither formula will come down when a new record is created.

Thanks.