called "ID" and has a data type "Number". It has unique values up to
565. I want users to be able to add records to this table but I want
the ID to be generated automatically and to increment by one each
time. Since there is already data in this field, I can't change its
field type to "Autonumber". So I guess I'm looking instead at creating
a default value of Max+1.
The name of my table is "Encroachments". I have tried just putting the
following in the Default Value spot:
Max([Encroachments].[OldID])
However, even though this doesn't have the "+1" yet, it causes an error
message: Could not find field 'Encroachments].[OldID'
I have tried various other ways, but none of them has worked.
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
