Retrieve data from a database - Delphi
Posted on 2005-05-03
I'm still a noob with delphi (nothing's changed since my last question).
This is for the same program as my last question, so if you're already
familiar with it great. If not, here goes.
I have a box where the mileage for vehicles is supposed to be entered.
Instead of the user manually entering this data each time there is an
update, I would like for the field to pull the data from the database
used grdServices grid. This is a grid on the same form where users
can add and remove vehicle service information. I.e. If a vehicle
has maintenance done on it and a user add this information along
with the current mileage of the vehicle, I want the above "mileage"
field to pull that data.
Here's what I've tried. I tried changing the tbl data for the edtMileage
and pointed it from tblVehicles to tblServices. This works and pulls
the data from the service table (the item that is listed first, which
is why I needed the descending data). The problem however, is
now when I try to click on add to add a new service record, it goes
to the last record, and opens that data for me to modify, it will not
allow me to add new reports.
I know you'll prolly need some code, so let me know what you need.