Hi Phil, Sorry I didn't make things clear (maybe I'll update the list?). Yes I solved my problem and feel really dumb. I didn't realize that the traceback is in the error page as a comment. Once I found that out, I saw immediately that the arguments passed in had a couple of extra fields that I didn't use (the master and detail tables share some initial fields). I took them out of the sql statement and the form, but I didn't remove them from the argument list. (Just an FYI, the system allows you to add additional detail records, the first one is autogenerated from the master)

Hi Tom,

I have been on vacation and can't tell whether you have solved your problem.

If you are still having problems email me. I am doing exactly what you want to do so I will dig through my code and send you some tested examples if you like.

Phil.

...

To followup my last post, I'm getting an exception when trying to use MySQL's "select LAST_INSERT_ID()" function:

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Tom Jenkins DevIS (http://www.devis.com) Can the denizens of this group enlighten me about what the advantages of Python are, versus Perl? "python" is more likely to pass unharmed through your spelling checker than "perl". An unknown poster and Fredrik Lundh, 11 Sep 1998