How to auto_increment

[usban]

Hi!! I am a newbie. i'm trying to build an SQL sentence that create a table with a unique id field wich auto increments when i insert a new row to the table.

I've worked a bit with MySql previously than with ODBC and there i used AUTO_INCREMENT to point the columns of this kind, but with ODBC i've tried to use it and it always returns en error message.

I would like to know if this can be done without the usage of any function or if i have to use them, how. Thanks

[cjaeger]

do the incrementing in fileMaker with auto-enter calcs.

either - use the automatic serial number feature

or -

use a relatonship and auto-enter max(serialno) +1

[usban]

Sorry but I don't understand you i am a complete newbie. What is the Filemaker??

Looking at your answer i guess that it is not able to do it directly njust with one table.

[Anatoli]

RE: Sorry but I don't understand you i am a complete newbie. What is the Filemaker??

Oh, boy....

What you are doing here if you don't know what is FileMaker???