Simone Paoletti wrote:
How do I clear the numerator automatic (id) of a data base?
thanks
It sounds as if you may have allowed Base to create an ID field as a
primary key, as it suggests when you define a table without such a
field. Why do you want to clear it? If there is a field in the data of
the table that you want to use as the primary key, you can just select
the other field as the primary key and delete the ID field:
* On the main database window, click on Tables.
* Right click on the icon of the table you want to change and select
Edit to see the table definition.
* Right click on the beginning (unlabeled cell) of the row
containing the desired primary key and select Primary Key.
* Right click on the beginning of the row containing the ID and
select Delete; confirm.
* Save the table definition and exit.
If you don't have another field you want to use as the primary key, you
can define one that you will control, make it the PK, and delete the old
ID field. I wouldn't recommend having a table without a primary key; in
my experience, edits may not be stable that way.
If this doesn't address your problem, please describe a bit better what
you are trying to do, and we'll try to help.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
