>I have two tables with a common field. It is called an edr index number. The first table shows the edr index and common info in other fields. The second table lists the edr index number as many times as it has been summitted for approval with particular dates associated with the particular submittal instance. I need one form to show both the main info and list the submittal info. I want the edr index to be the driver for the form. Please Help.
>
>God Bless,
>S. Dyke
I think you need 2 grids on the form, one for the parent records(common info) and the second one which will show details. Second one can use a parameterized view as RecordSource.
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison