im creating a database of all of shopmobilities vehicles, for use in the workshop so we know things like tyre size, weight limits, battery sizes and so on.
I want to know if its possible to automatically fill in the vehicle details if it already exists.
The main screen looks like this:
primary key is the serial number field.
currently, you enter the serial number, fill in all the rest of the details and click save/next record and an error pops up if it already exists, saying:
is it an easy task to add it in, where the rest of the fields are automatically filled out if the serial number already exists?
or is it just to much hassle to add it in and requires redoing the main sheet which has taken me since november to get to this stage.
we are talking about a database which holds information of around 100 vehicles both past and present, if it helps with the decision of whether its worth it.


LinkBack URL
About LinkBacks


Reply With Quote
)

