sub form

[Alvarogue]

Okay - Your problem appears to be that you haven't actually got a table where all this information is pulled into - a transaction or any form of joining table.

You haven't defined what you are trying to actually achieve.

We know what you are trying to do with the table relationships, but you haven't actually told us what the purpose of the database is - In plain simple English.

Alright;

I want to be able to use the search combo boxes with the tables instead of creating another filter for the Navigation Form to work.
I also need the subform to let me add Multiple trucks for each company since its a One to Many relationship.

Does that work?

 

[Alvarogue]

Okay - Your problem appears to be that you haven't actually got a table where all this information is pulled into - a transaction or any form of joining table.

You haven't defined what you are trying to actually achieve.

We know what you are trying to do with the table relationships, but you haven't actually told us what the purpose of the database is - In plain simple English.

aNY IDEA???

 

[Minty]

Okay - I have had a good look at your tables and the layout/data and it definitely isn't right.

I don't understand how you are trying to relate / tie up the data.

Does the driver work for the company?
Can Any driver use any truck?

You still haven't explained in simple terms what the actual purpose of the database is?
To record journeys ? And who made them in what vehicle for which company ?

I would start a new thread with your Ideas / Explanation. At the moment you appear to have created a load of tables that you think you need and randomly linked them without taking a step back and planning what you are trying to achieve.

Draw it out on paper, in big manageable chunks. Then break down the Entities.

 

[JHB]

As mention in PM the database is attached.