OPO: How to force update of form to show trigger results...

Hello,

When inserting one type of record in table1, I want to create a record in table2 associated with the record in table1.

Of course, I can do that in a variety of ways. Currently I have a trigger but what I want to control is the way OPO behaves, so if it makes it easier to put the inserting code into OPO that's ok...

I have a form1 with datasource table1, and an embedded form emform2 with datasource table2 linked on a common key.

When I insert a record on form1, I would like the new record in table2 to appear right away in the embedded form. This is because the second table's record must be created along with the new record1.

I tried doing this on the OPO side by using emform2.InsertRow but this often caused a stack overflow, or just seemed to be ignored. That is why I tried doing it with a trigger. Which is fine except that so far the only way I can get OPO to display the new record, is to manually go to another table1 record, and then back again (but I have not been able to effect the same thing programmatically using commitform and query).

Puzzled.
Peter

-- 
Peter Yamamoto                     CS   Phone: +1 519-888-4567 x3299
University of Waterloo             MFCF Phone: +1 519-888-4567 x6488
Waterloo, Ontario, Canada N2L 3G1  Home Phone: +1 519-747-5318
Email: PJYamamoto_at_UWaterloo.CA     URL: http://daisy.uwaterloo.ca/~pjyamamo/