statsman
Active member
- Local time
- Today, 00:56
- Joined
- Aug 22, 2004
- Messages
- 2,088
I've never tried to do somthing like this so bear with me.
I am currently creating a database which tracks payment notices (tickets) issued by a private company to vehicles parked illegally on private property. One of the fields entered is the license plate numbr of the vehicle. After 10 days and no payment, the notice goes into default.
In order to follow up, it's necessary to get the owner info from the Dept. of Motor Vehicles. The Dept. will supply this but charges $25 per plate.
What I would like to do is check to see if this plate is already in the database and if so to copy the info into the new record. This would avoid the $25 dollar fee (would only have to pay once).
I would like to be able to click a command button on the form once the plate is entered.
What would be the best way to go about this?
I am currently creating a database which tracks payment notices (tickets) issued by a private company to vehicles parked illegally on private property. One of the fields entered is the license plate numbr of the vehicle. After 10 days and no payment, the notice goes into default.
In order to follow up, it's necessary to get the owner info from the Dept. of Motor Vehicles. The Dept. will supply this but charges $25 per plate.
What I would like to do is check to see if this plate is already in the database and if so to copy the info into the new record. This would avoid the $25 dollar fee (would only have to pay once).
I would like to be able to click a command button on the form once the plate is entered.
What would be the best way to go about this?