Hi all,

I have a database with 3 tables.

1. Companies table (holds companies details)
2. Activities table (holds activities details)
3. CmpAct table (holds Companies IDs and Activities IDs)

My pages are fully designed with DWMX 2004. Here is how everything happens:

Activities are added into Activities table. Companies are added into Companies table. When any company is added, another page comes up to add activities to the added Company. Activities come from the Activities table by the means of Repeat Region behavoir, each one has a checkbox. how can I select more than one activity for a desired table to pass the company's ID and activitys' IDs to the 3rd table (CmpAct table) as below:

For example:

CmpID ActID
1 1
1 4
1 8
2 2
3 5
3 9
3 10
...

Selecting a single checkbox to add only one activity to the company results in success, but selecting more than one checkbox to add more than one activity to a company results in "Data type mismatch in criteria expression" error!

Actually I'm looking for a way to loop the Insert Record behavoir of DWMX. I have searched the net for more than a month, but I have found nothing!

Edited by - rezasamimi on 15 Mar 2004 14:45:17

Edited by - rezasamimi on 15 Mar 2004 14:47:03