Query not working after deleting data from table

[Jerry]

I am trying to determine why two of my queries stopped working. I suspect it is due to me manually deleting data from the associated table. Now when I enter new data and run the queries no data is found although the new data is in the associated table. Looking for suggestions as to how to fix the queries.

Jerry

[RuralGuy]

Rebuild the queries from scratch and see if you get the same results.

[Jerry]

I have rebuilt the query. When I deleted the data it had a cascading effect across many tables and queries, however its only two queries that no longer retrieve data.

Jerry

[RuralGuy]

What you say makes sense if the "data deleted" affects the relationship of the tables.

[Jerry]

Any suggestions as to where to look as to why the query does not retrieve data?

The query is to print an invoice and is started from a print button. Everything appears to be working but no data is collected even though the data is in the tables the query looks at.

Jerry

[RuralGuy]

There are no records that meet the criteria of the query. You could also be using INNER Joins that return no records if there is no corresponding recoprd in both tables.

[Jerry]

It was me not entering all the data in all of the INNER JOIN tables. I will correct this so that data must be entered in these tables.

Thank you RuralGuy

[RuralGuy]

If you turn on Referential Integrity (RI) then Access can enforce these relationship rules for you.

[Jerry]

Thanks I will do that.

Jerry