Almost there just need some help
ok I am almost there - i found an old tutorial from Interakt (many to many) - been on the forums all weekend and i am almost there.
i setup my databases
1. profile - profileid, username, password
2. profile_category - categoryid, category
3. profile_categorylist - profileid_stc, categoryid_stc
Steps:
1. Insert Record Form
2. setup Recordset - Table profile_category, columns: all
3. setup my checkbox - picked checkbox from toolbar, checked value as:
<input <?php if (!(strcmp($row_Recordset1['categoryid'],WA_AB_returnPreSelectValue($WA_PreSelect_RelationalTable_1, $row_Recordset1['categoryid'])))) {echo "checked=\"checked\"";} ?> name="checkbox_<?php echo $RepeatSelectionCounter_1; ?>" type="checkbox" id="checkbox_<?php echo $RepeatSelectionCounter_1; ?>" value="<?php echo $row_Recordset1['categoryid']; ?>">
4. Applied the Repeat Region
Did a test of Form everything works great pulls the data from the Profile_category table
but insert won't work for profile_categorylist - profileid_stc but does insert for categoryid_stc
here is what i did for manage relational Table
Step 1: relational table: profile_categorylist
Step 2(where i think problem is): Foreign key column is profileid_stc, Data type: Numeric, key value: <?php echo $_SESSION['profileid']; ?>
Step 3: Foreign key column: categoryid_stc, Data type: Numeric, Option form field: 'checkbox' in Repeat selection (Recordset 1, 1)
pulling my hair out why i can't get the profileid to insert into profileid_stc in the profile_categorylist - PLEASE HELP!!!!!!!!!!! i can forward you files and databse if that helps
url of reg - profile_Registration.php