Ok - first please 'reply to all' for this message. While I have sent a subsribe to the list, I have yet to receive any mail from it, so I'm not certain that it is working for me yet. Now, I've got Zope and the ZMySQLDA stuff installed on my Linux box, and it is working just fine. I can connect to the database, and I can insert values and do selects. Now I'm trying to get a little tricky, and after pouring over the documentation, I realize I have no idea what I'm doing. . . . So maybe someone here can point me in the right direction. I have a database connection on the top of my hierarchy. I have several folders under the hierarchy in which I want to be able to manipulate different parts of the database. A simplified database scheme looks like this: user_table ( id int auto_increment, l_name char(30) not null ) data_table ( id int auto_increment primary key, name char(30) not null, submitter int references user_table(id)) data_table2 ( id int auto_increment primary key, keyword char(30) not null, d_id int references data_table (id), u_id int references user_table (id)) Now, I have a ZMysql method that takes as an argument the lastname, and returns the user id. I want to have a method for inserting into the data_table that does uses this value: ie, it should look like this: Last Name ************ Name *************************** Keywords **************************** and populate both the data_table, including the submitter id, and the data_table2. So my questions are: a) how do I get the sql_method that I am using to look up the id# for the user based on the LastName and insert that value into the data_table? I have something like this: Arguments L_Name:string:required name:string:required keywords:tokens INSERT INTO data_talbe values ( "", '<!--#sqlvar name fmt=sql-quote-->', ??????????????????? what do I put in the ?????????????? to make it work? b) then I have an sql_delimeter line, and I want to iterate through the keywords tokens and insert a record into the data_table2 for each of the keywords, including the submitter id# and the id# of the just inserted record from data_table. How do I do this?? Thanks for the help. I realize that this is probably pretty basic to some of you folks, but I am really struggling with this and finally decided to come begging for help. If you need more info, please ask. Dave --NAA25068.915047169/plato.healthpartners.com--