As far as I know the internal database unique id is inaccessible from outside (or even
inside) Filemaker, so don't bother trying to use it
You can do serial numbers in variables, but I wouldn't recommend it. I'd use a Global
field in FM to store the current serial number (generated from whatever scheme you
like) and punch this into the serial number field when the record is inserted. You can
then increment the Global field ready for the next insert
A good reason not to use the internal unique id, as a key or for anything else, is
that this value may change, I believe, under certain circumstances. These may include
saving a compressed copy of the database
I'd use your own generated unique ID as the key, always, with FM
>I'm using witango on a Mac server linked to a filemaker database which is used as a
>job booking system. What I would like to do is provide a job ID number back to the
>person booking the job when they add a new record, in the response page. The manual
>says that witango can do this and will get the data back from the newly created
>record, but goes on to say that the primary key columns must appear in the Columns
>list of the builder. This is where I get a bit stuck. I have included what I think is
>the correct field name in the response html, but get nothing. I have tried to drag
>the special record ID field into the Columns of the record building and I get a
>message to say that it can't be put in the the list as it's a special field.
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body