Lookup tables & inserting records

[akstudio348653]

Hi

I have a question.

Basically.. how can submit one form into two tables.

The primary key/foreign key across 2 tables is needed in this situation, but table 'B' doesnt update based on the records inserted into table 'A' using Data Assist.

Of course I can cascade the deletion of a record in table 'A' and have it removed in table 'B' - but how can I do the reverse.... insert into 2 tables based on one form.

I'm using DWCS4 and have the webassist suite to work with.

Thanks

[Ian]

Hi,

Can't you just add to Insert Behaviours onto a page that are both triggered by the same button - but on the first one you would not add a redirect page so it would execute the second insert behaviour?

Thanks
Ian

[Ray Borduin]

That is correct Ian, you can also use the "maintain relational table" server behavior if you want to do a one to many relationship in the two tables based on a multiselect list or checkbox group.