Rodrigo Quezada
|
Posted: 02/18/2004, 4:13 AM |
|
Hello to all... I have three tables, one with the details of a vehículo(placa, marks, model, etc.), another one with maintenance intervals preventivo(cambio of motor oil every 48 days or 15,000 km), etc.) and other than is called maintenances to make, whose fields are: IDVEHICULO, INTERVALOMTTO, ETC.. WHAT NECESIOTO TO DO IS... THAT WHEN Llama To the FORM INTERVALS TO MAKE, And SINGLE I ADD The VEHICULO, THIS SINGLE TABLE, TAKE The VALUES FROM The TABLE MAINTENANCE INTERVALS And GENERATE A LIST OF THOSE INTERVALS, SPECIFYING The DAY THAT TOUCHES To HIM, Or To the KILOMETRAGE THAT TOUCHES To HIM, FOR EXAMPLE TO CHANGE OIL, ON The BASE Of PRESENT Km Of the VEHICULO. UFFF. PLEASE HELPME
|
|
|
|