Add record with related multiple records

[Heather_Mann]

I have a form Blogs which has a multi-select field Tripbits. In my database I have Blogs, Tripbits and Blog_Tripbits tables. When inserting a new blog I need the blog to post and then the multi selected tripbits to post to the Blog_Tripbits table with the blog_id and the tripbit_id (value from each multi selected item). I know I can get the blog_id and then use a repeater in the server connect but I can’t figure out how to get the array value of the multi-select Tripbits field to the repeat.

Thanks.

[mebeingken]

Hi Heather,

Maybe this will help you:

For a multi-select input, the POST parameter needs to have the Multiple box ticked. Then you can setup a repeat to access that array, or otherwise reference it.

–Ken

[Heather_Mann]

Sweet. Thanks.