I have a form that shows an EDR number(Engineering Data Requirement). It comes from a one-side table. On the form I have a grid that shows how many times this EDR has been submitted. It comes from a many-side table. The I have a PK on the first table based on the EDR number. I have a regular index on the second table based on the EDR number. I have the tables related in the DE from the PK to the RK. In the Data tab of the grid I have the ChildOrder set to the RK. The LinkMaster set to the first table. The record source set to the second table. The RelationalExp set to the PK. I get the records I want on the form. However, the submittal numbers are not in order. How can I get this order correct. I have tried basing the RK on EDR number + EDR submittal but the data shown in the grid is very inconsistent. Please Help.

God Bless,
S. Dyke