>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
Steven,
I would say change your index expression to reflect what you want. You already seem to have done that. What do you mean by "inconsistent" ?
ie: If child grid link field was patient_id and I wanted to see last visit first, I would do like this :
index on cPatient_id + dtos(dVisit) tag main descending
* Childorder main
* Linkmaster Patients
* RelationalExpression Patient_id
No relation but order in DE (set to main).
Cetin