I need to use a view with a lot of tables. For various reason but mostly
because relations are needed to be displayed in a grid, which at least in
vfp5 doesn't work well. I'll simplify for my example.

parent child
---------------------
Order orderdet
orderdet prodcode
orderdet prodname
orderdet prodtype

Here's what I have done...

View1 -> order
view2 -> orderdet, prodcode, prodname, prodtype

Then view1 relates to view2.

But I'm wondering if the view should be...

view1 -> order, orderdet, prodcode, prodname, prodtype

...and do away with the relation.

I will be appending records to the view and updating the tables.

Which is the better way to do it?