>I am looking for a best-prctice approach to mamy to many table scenarios:
>I have a parent table, an intersection table and a child table
>in a form I show the parent info and in a grid the child info and maybe one or two field from the link table
>I imagine a cursor adapter containing link data and child data would be the BEST way to populate the grid from
>
>now the big question: can I insert a record into the cursor adaptor cursor and have the adaptor automatically add a record into the link table AND the child table \and how must this CA be set up??
>
>Thanks
>
>Peter
I would
suspect that the situation is similar than, say, local or remote views. Now, it is fairly problematic to update more than one table with the same view, and I have seen recommendations - and follow them myself - to update only one "main" table per view, and include other fields only as a reference.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)