Object dependencies

[Rob S]

If you have a Query depending on a table and it shouldn't be, how do you correct it?

[June7]

Depends on it how? Is it in the query by join or is it referenced some other way in the query
Use the Query Designer to modify query.

[Rob S]

It's a database full of part #'s. We have a 1776 query that relies on the 1776 table (1776 is one of our part #'s etc.), and 870 query that relies on the 870 table. We also have a 2001 query that also relies on the 1776 table. It should be getting it's information from the 2001 table, but it's not. I click on the object dependancy database tool and it tells me it is relying on that table. i go into the properties, and i can't find that they're connected anywhere. I tried the Query designer, and it wanted to create a new query. i don't want a new one, just to fix this one.

[June7]

Open the existing query in DesignView and edit.

Why do you have individual tables for parts?

Want to provide db for analysis? Follow instructions at bottom of my post.

[Rob S]

They are lab test sheets and have different requirements for testing. I will try your last suggestion. thanks.