[AccessD] Row number in form

I see.  Thanks for explaining.  I still don't see any real reason for it
since it doesn't identify anything and it gives the user a false feeling
that the rows have meaningful numbers.

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Tuesday, January 22, 2008 8:44 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Row number in form

Hi Charlotte

It's up to you, but I think it mainly would be for display in a form.
Even if you have to browse records in list view, you can easily see -
when you enter a new record - which number it has without having to
display the native record navigator bar.
If you delete records, however, you'll get into trouble as the numbering
of existing records may be false while any new record will be numbered
correctly. If so, the records could be renumbered by one cycle through
the RecordsetClone of the form.

/gustav

>>> cfoust at infostatsystems.com 22-01-2008 17:27:50 >>>
But what purpose does it actually serve?  Wouldn't a CreatedBy and
CreatedDate field make more sense?

Charlotte Foust