>I'm planning to do some VFP programming in the near future (V5.0 and I have V6.0 on order). It seems that Views are an ideal solution to the multitable join problem. It seems that the VFP V5.0 One-To-Many Report Wizard accepts Views as the Parent, but will not accept a View as a child. I can this possibly being a problem given that Views don't have indexes(????).
>
>Any suguestions on how to uniformally represent AND report data from multiple tables?
>
>Thanks,
>Don
You can index view, and set relation, however, IMO, views are not exactly for reporting, because you are not going to update data there, and cursor which is exactly like view (just no automatic updating) is better suited here.
Edward Pikman
Independent Consultant