Automating Field

[Fakhruddin Zavery]

Hello All,

How can one automate a number sequencially? What I'm trying to do is create
an invoice system and I want the Invoice Number Field to be generated
automatically whenever I create an Invoice or Select a Customer to create an
Invoice for?

I have simple four tables (Customer / Invoice / Invoice Details / Service)

All the help will be appreciated.

 

[pieter wijnen]

you'd need a table for that (to make sure the numbers are consecutive) in a
high impact environment you'd probably have to place the table in a d

 

[pieter wijnen]

you'd need a table for that (to insure consecutive numbers - without gaps)
additionaly yo'd need (fast) transactions to make it work in a multi-user
environment

a better approach from a (developers/my) point of view would be to create a
"lost" (invoice) number table to keep track of the data that was never
submitted to appeae the accountants (but then again I'm used to Oracle
Sequences..)

Pieter

 

[Fakhruddin Zavery]

Thanks

you'd need a table for that (to insure consecutive numbers - without gaps)
additionaly yo'd need (fast) transactions to make it work in a multi-user
environment

a better approach from a (developers/my) point of view would be to create a
"lost" (invoice) number table to keep track of the data that was never
submitted to appeae the accountants (but then again I'm used to Oracle
Sequences..)

Pieter

Hello All,

How can one automate a number sequencially? What I'm trying to do is create
an invoice system and I want the Invoice Number Field to be generated
automatically whenever I create an Invoice or Select a Customer to

create