paul.raeburn
PR
- Local time
- Today, 00:39
- Joined
- Apr 29, 2001
- Messages
- 47
I would like to check that a record exists in a table when a user enters data into 2 fields on a form...
it is travel database, it has a table called "travel_places" which has 3 fields called "travel_from", "travel_to" and "distance" on the from the user has 2 drop down combo boxes, the user choices the places here has travel from and to and is written to a table called "travel_dates"...
What I would like to happen is, once the user updates the 'to' combo box that the record is check to see if the details entered exists in the "travel_places" table if not present the user a message box stating that the record does not exist... and allow the user to update the table with the record including the distance...
is this possible...
Regards - Paul
it is travel database, it has a table called "travel_places" which has 3 fields called "travel_from", "travel_to" and "distance" on the from the user has 2 drop down combo boxes, the user choices the places here has travel from and to and is written to a table called "travel_dates"...
What I would like to happen is, once the user updates the 'to' combo box that the record is check to see if the details entered exists in the "travel_places" table if not present the user a message box stating that the record does not exist... and allow the user to update the table with the record including the distance...
is this possible...
Regards - Paul