Javier : >> Question 1: I have a form in which I display information on a vehicle and I would like to display a lookup variable with the lowest (MIN) mileage for that vehicle based on information on maintenance intervals for different maintenance procedures stored in a separate file (schedule). Right now I use an eep to calculate this value on entry to the row.: <<
Try a (temp) view with a dynamic WHERE clause to get the lowest mileage (WHERE ColName = .vVarname) Then, create vVarname in your code before calling the form. Assign a value with an expression into the form. Get the view's column with a look up and display it on the form. Regards, J.M. GRATIAS, Logimatique
