Hi Steven.

>> 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. <<

You can create a parameterized view for the child table. This view is simple enough that it can be created in the view designer. Just use the common field to relate the two tables and under the filter tab enter the field in the parent table and specify that it should = ?vp_edr_index_number.

Use the paramterized view as the RecordSource for the grid that displays records from the child table. Specify NoDataOnLoad = .T. for the parameterized view in the DE.

If you are displaying the parent table in a grid, just set

vp_edr_index_number = Table.Field
REQUERY( '' )

in the parent grid's AfterRowColChange.

If the parent is being displayed in a combo box, put this code in the combo's Valid.

Marcia