Matrix Type lookup

[TheReaper]

Hi,


I have been searching for an answer to my problem and hoping someone will be able to help.

I have 2 tables - Day Planner and Vehicle Permits.

In my day planner table I have 3 columns. Truck - Trailer - Permitted

The columns Truck and Trailer are both looking at to other tables with all the vehicle information stored in them.

When I select a Truck and a Trailer in their respective columns in the day planner I want to be able to check the two vehicle details against the third table which is the Vehicle Permits table and the return a vaule store in a column in the vehicle permits table to populate the Permitted column in the day planner table.

Anyone have any ideas how I can do this?

I have tried a the lookup wizard/ creating a query but to no avail as yet.
thanks

[June7]

Why save permit info into daily planner? Could just do a query that has compound join on truck and trailer fields. If you already tried Dlookup or query, why didn't either work - error message, wrong result, nothing happens? Show attempted code or query.

[TheReaper]

thanks so much for a reply. One of the issue is that the Day planner is a list of vehicle routes and then each day a different vehicle and trailer combination gets selected. I want to be able to check the user inputs into the table against the Vehicle permits table to return the value and populate the Permitted field in the Day planner.

[June7]

I understand that and my question and suggestion remain same.

[TheReaper]

I understand that and my question and suggestion remain same.

Thanks, I will keep working on it.
Regards