Manage Relational Tables - can't get it to work.

Hi, I'm attempting (for the first time) to create a "Manage Relational Table".

I've created Detail, Insert, Search, Update and Results pages using the Data Bridge "DataAssist pages" function.

During the course of this I have set it up to create a list of options (called "Main Category"). This is displayed in list format so that multiple "Main Categories" can be selected.

I have created a main table (called "courses") an Options table (called "coursemaincategory") and a table for the join (called "coursemaincatoptions").

So far I have only attempted to apply this behaveour to the insert page.

With the insert page open, I opened up the Insert Record (course) behaviour and deleted the page redirection.

I then opened up a new Manage Relational Table behaviour.

On the first page I made the trigger "Button: Insert pressed"
Selected the connection and relational table (coursemaincatoptions)
I then set the "Go to" to "courses_detail.php?CourseID=<?php echo $_SESSION['WADA_Insert_course']; ?>" WADA_Insert_course is the session that Dreamweaver/webassist created.

On the next page I set the Foreign Key column to "FKcourseID"
Data type to Numeric
and the key value to "<?php echo $_SESSION['WADA_Insert_course']; ?>"

On the next page The Foreign key column was set to FKmainCatID
Data type to numeric
Options form field to "'FKmainCatID' Multi-select box"

The next page reported:
mainCatOptionsID Numeric
FKcourseID Numeric Automatically bound master key field
FKmainCatID Numeric Automatically bound joined key field

Clicking finish created "Manage Relational Table (coursemaincatoptions)" in the server behaviors panel.

I then tried it out by inserting a record. (This was on my local machine, none of this is on a server yet). The record was inserted into the courses table but the data inserted into the relational table (coursemaincatoptions) was


mainCatOptionsID FKcourseID FKmainCatID
1 1 0
2 2 0

As you can see the numerical values for the FKmainCatID were not entered.

I've spent quite a few hours trying to figure this out and I'm pretty sure I'm doing it correctly but am open to being wrong :-).

I've attached the files as well as SQL dumps of the tables.

Any pointers in the right direction on this would be appreciated.