>Hello Group,
>
>I have five table and each tables primary key is a foreign key in the next table. What would be the best approach to updating all of the tables with one form. FoxPro 6.0 doesn't seem to have subforms. Do I use grids?
>
>Thank you very much.
>
>Thanks
Jim,
Use a pageframe with grids on each page. You could set up filters for each child table in the AfterRowColChange event of the Parent table's grid.
Or you could set up views and requery in the AfterRowColChange event. This is a little trickier because you have to deal with requerying a view that may/may not have pending changes. I have gotten around this in the past by propagating the top most parent's PK down to the children/grandchildren and requerying once when the top most parent is selected. When records need to filtered further in the grandchild views, I use the filter concept there. When you save the information, all records in the view (including the filtered ones) are updated to the source tables.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao