Query (relationship?) problem

[Dimmer]

I have five tables in my database. The main table has a primary key of EquipID. Two others contain info about Venders and Product Limitations. The final two I created because of many-to-many relationships.

TblEquip is linked to tblVenderRel (one-to-many on field EquipID), which in turn is linked to tblVender (one-to-many on field VenderID). The other two tables are linked exactly the same (except field names).

When I attempt to make a query with all five tables, only the Column heads for the fields choosen in the query appear; no data. When I make queries with TblEquip, tblVenderRel and tblVender or TblEquip, tblLimitationRel and tblLimitation separately, they work fine.

Can't figure out what the problem is. Any help GREATLY appreciated.

Thank you
Brian

 

[smoker1]

As you have assumed, it is a problem (most likely) with the join properties you have established. Start with one table and query the information (with any applicable criteria)from that table. If data appears, add another table... and so on.

This way you will be able to limit the problems to one table and can research from there.

Hope this helps!

 

[UncleJack]

When you say your have tables linked to one another are you referring to establishing relationships? If so, try deleting all those troublesome relationships and then write your queries and establish your relationships within the query. If this solves your problem then you've learned something about relationships that isn't published in the Microsoft guides.

Uncle Jack