Manage Relational table

Have done this a while ago, but not using databridge.

I have gone through the bluesky tutorial twice and cannot get the insert or update pages to work properly.

in the insert and update record behaviors, you have the Primary key itemID column bound to a form element.

The primary key column should not have a binding, the database will manage the value of the ItemID column automatically.

you're right, don't know why i did that.

However, I started again and I have the same problem.

The simple insert and update work fine, the mrt does not insert any rows into the genres table

using blue sky database and tutorial

can you send the latest copy of the pages.

oops, sorry I forgot the attachment

1) add the following to line 1 to force the page to find the session:

<?php @session_start(); ?>

2) the code forthe value of the genre hidden form element has a trailing space:

value="<?php echo $row_rsGenres['GenreID']; ?> "

it should be:

value="<?php echo $row_rsGenres['GenreID']; ?>"

Thanks Jason.

That seems to have been the issue - all working fine.

Now that I have tested the theoretical solution, I have an additional question.

I have a number of many to many relationships, whereby the items table is linked to different options which are item specific.

do i add several mrt server behaviors on the same page ?

Thanks

yes, you can add multiple MRT behaviors to the page.

great.

onwards and upwards..