I have attached to JQuery files and a Coldfusion file. The Coldfusion file just needs the extension changed from .cfm to .html in order to get it working locally unless you have CF installed on your machine which is not a requirement.
Once you have the .html file working, you will see that there is a button at the top that says "Add Query" and within each block that is added there is a button that says "Add Join". The "Add Query" button adds a new block to the screen and the "Add Join" adds another join for the query.
I started working on this but I don't have the time to complete it. The code can be modified and changed and it doesn't necessarily have to use the validate plugin dynamic row. I am open to using the clone() feature built into JQuery as I did in the addQuery() function that I created. I would prefer to use the core functionality of JQuery vs. using the plugin, but either way is fine.
The fields should be dynamically named in the following way:
Query 1 Join 1
fieldA_1_1
fieldB_1_1
fieldC_1_1
fieldD_1_1
Query 1 Join 2
fieldA_1_2
fieldB_1_2
fieldC_1_2
fieldD_1_2
Query 2 Join 1
fieldA_2_1
fieldB_2_1
fieldC_2_1
fieldD_2_1
Query 3 Join 1
fieldA_3_1
fieldB_3_1
fieldC_3_1
fieldD_3_1
Query 3 Join 2
fieldA_3_2
fieldB_3_2
fieldC_3_2
fieldD_3_2
Naming it like this will make it easier for me to loop the fields on the processing page and work with the data. I think that should be self-explanitory. I believe at the moment, the fields look like this: fieldA-{0}, fieldB-{0},... I prefer the underscores, this was a script I found that I modified which apparently I didn't modify everything.
Depending on how clean and how good of a job you do, I have another JQuery job that I need done as well. Whoever can perform fast and do some clean work will receive many more projects, both small and large, that are involved with JQuery.
Please look at the attached files and ask any questions that you may have. I need this done as soon as possible.
Thanks you in advance!