Re: New ID

Brian,

> What I don't know how to do is to get that newly created note_id so
> that I
> can insert it into the palm_memos table
>
> Any ideas / advice?

Easy (please taylor to your programming language):

BEGIN TRANSACTION;

INSERT INTO notes (fields)
VALUES (new stuff);

$variable = SELECT CURRVAL('name-of-sequence-for-notes_id')

INSERT INTO palm_memos (notes_id, other fields)
VALEUS ($variable, other fields);

END TRANSACTION;

Make sense?

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco