>What I have is a address to contact relationship where I have a form that show one record at a time (too much data for a grid). If I create a standard view from 2 tables (flat file) and append, both tables are appended.
>
>If I create separate views I can't keep them in sync. Currently I've created my own updatable cursors and set a relationship between the parent and child.
I mean that you create parameterized view just from child table, and modifying it you affect child table only. Also, I wonder what means too much data for grid. If you have many child records associated with particular parent record then you can always add search functionality to your grid.
Edward Pikman
Independent Consultant