Auto Increment

[ScottA]

I am developing a form that will be used to enter large
quantities of records in a single sitting. For many of
these records, the field values are duplicated, so I've
used the button Wizard to add a Duplicate Record button to
the continuous form.

One of the fields is a numeric value, which should be
incremented by one for each new record added in
this 'batch'. I'm wanting to do a little re-programming
on the button so that it duplicates all of the field
values for the record selected AND increments the value in
the numeric field.

Any ideas?

Thanks,

Scott A

 

[John Slattery]

If much of the data is duplicated from record to record, it suggests to me
that possibly these groups of records are related in some way. If that is
true, you may be able to facilitate data entry and simplify your form
development considerably by normalizing the data, for instance, creating
customer, order, and item tables from a single table that currently contains
all of this data. You would not have to worry about incrementing your
counter value as each of the tables could have an autonumber field. For
what it's worth ...