On Tuesday May 30 2006 11:22 am, Josep Castells wrote:
> Dear Sir,
>
> I'm trying to create a base that I 'd need to insert a numeric counter
> for serial number registers, this may be:
>
> - similar 'Id' field like Msacces', as automatic, is this
> option in openoffice?
>
> - or with a formula inserted on a numeric field, how can
> introduce the formula: defect value= record()+1 ?, on the table, on the
> form, in a macro? which are the correct tense? In fact the value has to
> be upgraded on the table.
> I have not found the formulas and how to edit my macros of current
> version.
>
> Please may you help.
> Thank you very much,
> Josep Castells
>
> [EMAIL PROTECTED],com
I think you are referring to a Primary key for a table. As you create
the table, set your numerical counter field as the Primary key. Its Field
Type must be Integer[INTEGER]. Set AutoValue to Yes.
When you do this, this field will automatically increase in value for
each record for this table.
This might be better explained in the "Getting Started with Base"
chapter available at
http://documentation.openoffice.org/manuals/oooauthors2/index.html.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
