update a table but for the current record?

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
 
M

Maarkr

you may need to explain your table setup...Is your JobDetailID linked to a
foreign key field in Car Details table?
 
D

DH010010

yes the two fields are linked.

Maarkr said:
you may need to explain your table setup...Is your JobDetailID linked to a
foreign key field in Car Details table?
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table/Form - Not sure what else to put 2
Count ID from one table that matches another and show in a form... 2
Dlookup question 4
Missing Record Details 1
simple question but no answer on any access forum! 4
Recording date of change in table 6
contacts template- adding a second table 3
Append only current record in a form to a table 4

Top