Help.....very Confused!!!!!

[JustMaybe]

hi..am soooooo confused..

I'm creating a query as a basis to create a 'order report'

I have picked the various fields i need for this query..however...when i choose the field 'Supplier ID' i find the query will only display the records if the ID is 2! if i put an entry in my form where the ID is 3, 1 or any other number the query misses the entire record!!! Everything else seems to be working fine.......

Some info (not that i'm even sure its any use!)
SupplierID is a primary key in my supplier table. I am selecting the supplierID as a record from my 'Orders' table and then details such as 'Cuppliers Company Name' is coming from my supplier table.

has anyone seen this before? am i missing anything simple...any reply will be very thenkfully recieved!!!

 

[qwkslvr1999]

Can you post your query?

 

[JustMaybe]

thanks for your help, but i've solved the problem!!

 

[Fastone]

Could you tell me how you solved the problem? It could be useful for the future.
Thanks

 

[JustMaybe]

A very simple solution!!

Turns out that when i added my supplier table to the query it formed a link to my 'order' table. This relationship was not in my relationship diagram, and was not intentional!

This occured because i had supplier ID as a primary key in my supplier table.
Supplier ID was also a foreign key in my orders table. However these two tables were never meant to be actually joined.

The product table which which was between both the supplier table and the order table, resolving my many to many. Was also linked to them both and my query therefore had a many to many relationship.

bit long winded...but the points there...

I seem to always spot the problems once i've left the database alone for a few hours..otherwise its so easy to miss simple mistakes!!!