Linked Table in a Query

[Guest]

I have a guery with 6 tables in it.

Table 6 is a linked table.

When I run the query, it gives me 566 records but will not allow me to
change data in Table 4.

I then, copied the linked table into my database so its local and remade the
query with the local table 6. When the new query runs, it only shows 366
records.

I have checked the join properties in the new query and they are the same as
the old. Why would this be happening?

 

[G. Vaught]

Generally, you should not get different results. However, depending on the
join type of the queries, you could get different results. What you need to
first determine is what the actual results should show; 566 or 366 or
something even different.

Keep in mind different results could be the product of duplicated records.
Queries have three types of joins. When in the query right click on the one
of the join lines and look at the different possibilities.

When using multiple tables in a query you will most likely prevent the query
from being updateable, thus you can't make changes. This is for your
protection. You can't add a child record until a parent equivalent exists.

Hope this sheds some light and helps with your problem.