Thanks a lot. Both controls worked well.

I was not able to cleanly place the add form html part ---

<select id="cat" name="CatID" onchange="loadSub(this.options[this.selectedIndex].value)">
<%loop cats%><option value="<%CatID%>"><%Cat%></option><%endloop%>
</select>
<select id="subcat" name="SubCatID">

I am using the 'default' template set. I have placed the above code in the add_form.html template which duplicates the controls.

One set of Category and SubCat are being displayed because of the sub create_listings being called in Dbsql::Relation::HTML::generate_add_form or Dbsql::HTML::generate_add_form. I could not figure out how to suppress them. How does one suppress them?

Thanks once again.

TIF