>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.
>
The usual method is to have the common info from the first table in text boxes on the form and then have the related information from the second table displayed in a grid. You can relate the two tables together in the data environment, using the grid properties or in code. HTH
Shane
--Shane