D
DH010010
i have two tables. on whic holds job detail and another that holds car
details and the hire dates.
forn the first table using a form details are entered and you can create a
hire form which have a drop down box with pre defined details. when they are
selected the hire form is created and printed. my problem is that when the
details are saved in the car table they are not always the current details.
it seams to be storing thim according to the id number.
the table is telling me that the vehicle is hired and returned but it is
not. uit does not show the correct dates. it seams to show the dates for the
lates id number and not the date.
ie id 130 had the car first and it has been returned and id 12 has the car
now but the table showes details for job 130 and not 12!!!!
how can i fix this.??? you help would be great
details and the hire dates.
forn the first table using a form details are entered and you can create a
hire form which have a drop down box with pre defined details. when they are
selected the hire form is created and printed. my problem is that when the
details are saved in the car table they are not always the current details.
it seams to be storing thim according to the id number.
the table is telling me that the vehicle is hired and returned but it is
not. uit does not show the correct dates. it seams to show the dates for the
lates id number and not the date.
ie id 130 had the car first and it has been returned and id 12 has the car
now but the table showes details for job 130 and not 12!!!!
how can i fix this.??? you help would be great