adding records

[sarinder]

hi everyone,

look at these codes:

<INPUT TYPE="hidden" NAME="-FORMAT" VALUE="newcojobmodels.html">

<input type="text" name="CoID" value="[FMP-Field:CoID]" size=10>

<input type="checkbox" name="JobID" value="00" checked>Top Management Executive

<input type="checkbox" name="JobID" value="01">Senior Manager

<input type="checkbox" name="JobID" value="02" >Manager

<input type="checkbox" name="JobID" value="03" >Developing Executive

<input type="checkbox" name="JobID" value="04">Director of Human Resources

<P><INPUT TYPE="submit" NAME="-New" VALUE="New JobModel">

<P><INPUT TYPE="reset" VALUE="Clear Form">

What i would like to do is add multiple JobIDs with the same CoID.The problem is when check more than one check boxes and press the submit button, only one record is added in the database. How can I tackle this.I know the problem lies in the CoID field which i'm trying to add more than one time...but I fail to figure out how to tackle it.TQ

[Keith M. Davie]

"(Part 1)What i would like to do is add multiple JobIDs with the same CoID. (Part 2) The problem is when check more than one check boxes and press the submit button, only one record is added in the database. "

ans.(2): of course only one record is added to the db. One record is all you have created.

Please check my response this forum: "ValueListCheck doesn't work". It may help you understand an answer to Part 1 of your question. Think Different.

SIMPLIFY ...

Keith

[flexistentialism]

If you want multiple JobID's on the SAME record with the SAME CoID make each JobID check box fill a different field in the record eg JobID1 JobID2.

You can also concatenate values from many form objects into one field using JavaScript pre WC or calculation field on the database.

If you are trying to add more than one record at the same time each with a different JobID but same CoID then see above.