What am I doing wrong?

[Dan19]

Hi Everyone, Great forum you have here, very lively.

I've got a problem with a very simple and small access database, I just can't figure out what I'm doing wrong.

I think my tables are structured wrong, because I can't make any queries.

If someone could take a quick look and tell me were I'm going wrong that would be great!!! Should be pretty easy for you Access guys.

I've attached the database in a zip file, its only 40kb.

Thanks in advance,

-Dan

 

[Oldsoftboss]

What queries are you trying to create?

 

[Dan19]

OldSoftBoss,

Thanks for helping me out,

All I need for queries is -

1. Display all clients who ordered air conditioner id number 2
2. Display details of all air conditioner units (this doesn't need a query? just a report?)
3. Display all orders from client id number 1

Then I can just turn them into reports,

Thanks again, I owe you one

-Dan

 

[snoko]

Dan,

You haven't entered in the Orders table which orders are for which client or A/C unit !

 

[Dan19]

Thanks everyone,

I took what Oldsoftboss did and made the queries and reports for it.


Thanks again guys,

-Dan