Help with Driver Log Form

[Craiger9er]

Hey all, I'm fairly new to this and need help with a form. This is what I have and am trying to do.

I have 3 tables

One table is the Driver / Driver Number table

One table is for the date and miles

One table is a log for their deliveries.

On the form, I want to be able to enter the Driver name, date and starting and ending miles.

AND

Their deliveries probably need to be in a datasheet view is my guess, and would mark their hours and delivery. So on one date, they may have 6 different times with deliveries.

What I've tried...

I have a form with date / miles, and a subform with their log. I used a relationship between the date, but the problem I ran into is if Bob 6 deliveries on 01/01/08, then when I go to add Chuck's deliveries, I enter his name and date, and then Bob's 6 deliveries show up, because of the date.

Any help would be greatly appreaciated

Thanks

 

[CraigDolphin]

Your main form should reference a minimum of three bits of information...driverID, date, and 'miles'. These are fields in the table your form is bound to.

Your subform is bound to a 'logs' table that, likewise, must store information about driverID and details for the delivery. Otherwise how does the db know which logs belonbg to which driver?

Then, use both the date field and driverid field to create the master-child link between the form and the subform. Note: a control bound to the driverid field must be included on both forms but it can be set to be invisible to the user.

 

[Craiger9er]

Thanks for the help, I appreciate it....I'll work on that and if I have any other problems, I'll let you know

 

[Craiger9er]

Thanks for the help

It worked, thank you....I had almost everything set up right, except for binding the driver id / date

 

[CraigDolphin]

Glad you got it worked out