Dynamic drop Down with multiple insert

Hello
I would like to create a form with three menus link by your dynamic drop down methode.
It's work fine -)))

But now I need to use the multiple insert on this form and when a do this the dynamic drop down does't work.

Is it possible to use multiple insert (or update )with the dynamic drop down menu ?

Best regards
G.S

No, dynamic drop downs is not compatible with the multiple insert.

Bad new for me, any project to go that sens in the futur ?

It is possible to do this with jQuery dependant dropdowns like the ones I have here index.html

When I have a few minutes spare I'll write up a blog post on how to achieve this.

Hy Dave,
can you give me the link to download the jquery source please, I'll try to do it with the multiple insert.

I also work with document.php?id_doc=62, very powerfull +++ because with one recordset you can link up to five or more menu.

But to make it work with the multiple insert, we have to put also the hand in the motor like with the WA solution...,

Otherwith there is the ADDT solution, I'm not sur but I think it menage the mixt dynamic DD * multiple transaction, as I try to go with WA now I'm looking for a direct solution if possible.

This is the code for the jQuery Plugin

/*
 * jQuery Dynamic Dependant Select Lists
 */
function makeSublist(parent,child,isSubselectOptional,childVal){$("body").append("<select style='display:none' id='"+parent+child+"'></select>");$("#"+parent+child).html($("#"+child+" option"));var parentValue=$("#"+parent).attr("value");$("#"+child).html($("#"+parent+child+" .sub_"+parentValue).clone());childVal=(typeof childVal=="undefined")?"":childVal;$("#"+child).val(["'+ childVal +'"]).attr("selected","selected");$("#"+parent).change(function(){var parentValue=$("#"+parent).attr("value");$("#"+child).html($("#"+parent+child+" .sub_"+parentValue).clone());if(isSubselectOptional){$("#"+child).prepend("<option value='none'> -- Select -- </option>")}if($("#"+child+" option").length==0){$("#"+child).prepend("<option value=''> -- No Options Available -- </option>")}if($("#"+child+" option").length==1&&$("#"+child+" option").val()==""){$("#"+child).empty().prepend("<option value=''> -- No Options Available -- </option>")}$("#"+child).trigger("change");})};

you will obviously need to include jQuery itself as well.

Hi Dave

Does this code work independantly of WA Dynamic Dropdowns? Do you have a tutorial you can point me to? I am a J query novice.

I am looking at the code you have posted but have no idea how to implement it.

Your Help is much appreciated

Jenny,

describe what you are trying to achieve and I'll do my best to help you.

Thanks Dave

I am trying to incorporate a dynamic dropdown with data assist multiple insert.

I have a table in my database called mediaLibrary. I have created an upload folder called Media-Library in my site root and all files uploaded go in this folder.

Basically I am trying to create a website where an admin can create training series that can be viewed on the public site (a bit like lynda.com). I am currently making the admin part of my site.

In order to make my site scalable I had to create a table (mediaLibrary) that stores all files, another table (trainingLibrary) that allows users to select items from the mediaLibrary table. I then have another table called trainingSeries and the primary key for this table is stored as a foreign key in the trainingLibrary table.

So say for example an admin wanted to create a new training series with 20 videos. I would like to apply dataassist multiple insert and your jquery solution on the trainingLibrary insert page, where the mediaLibrary table would be the child and mediaLibraryCategory (e.g. audio, video) would be the Parent table.

Have you got a multiple insert/update form set up yet ?