Simple database problems

[CHowell2005]

I'm trying to make a simple database to help my fire department with putting together running routes. I'm having an issue with getting the one to many relationship working correctly as well as a dlookup function continually gets a #Name? error. How should I upload my DB so you guys can help me out.

[Ted C]

On the Post New Thread / Post Reply form (not the Quick Reply form), there's a paper clip icon for attaching files to your post.

[CHowell2005]

What is the most commonly used access version on these forums, I am using 2007.

[Ted C]

What is the most commonly used access version on these forums, I am using 2007.

Just be clear which version you're using in your post; someone with the right experience will answer.

[CHowell2005]

So I'm going through and making directions to all the major intersections from the firehouse. This happens under the intersections table and form.

Then I want to use the routes table and form to make specific directions to streets and splits. To make this faster I want a listbox(Intersection Name) to select the nearest major thru intersection for that address. After selecting that intersection I want it to copy that intersections directions to the runningroute field which I will then add the few remaining directions to finish that route.

I think DLookup is the function I want to bring the intersection route from the intersection table to my runningroute field in the route form. However, I can't get it to work correctly, and I've tried several different formats/syntax. I'm also having a relationship issue with 72route form creating an entry in the 72route table even though I have the one to many relationship set up.

Note I also want it to save the nearest intersection that I select to be referenced later when I export the information to be printed.

This is in access 2007, I hope I explained my problems well enough.

[CHowell2005]

Can I get a bump

[CHowell2005]

Relationship issues fixed
This is an updated file.
Still having problems getting the IntersectionRoute value moved to the RunningRoute field in the 72Routes form when I select an IntersectionName.