Lookup tables & inserting records

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

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

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.