Lookup tables & inserting records
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.