Query joins not created in front end query grid

[Bob Darlington]

I have two tables (among others) which have relationships and ref integrity
established and a primary key in one table and a matching field (same data
type) in the other.
Both tables have data.
I can manually create links in the query grid in the front or backend.
If I add the tables to the query grid in the backend, the joins are
automatically created and reflect the one to many relationship eastablished
in the Relationships window.
However, in the front end, when I add the tables, no join is created. When I
create it manually, the one to many symbols are not created.
I'm using Access 2002 with all SPs.
Any help appreciated.

 

[Allen Browne]

Hi Bob

The absence of the one-to-many symbols in query design should not make any
practical difference to how the query runs. Sometimes Access is able to
figure it out; sometimes it cannot (e.g. if the table is aliased.)

If you want to try to solve this, you could try a compact/repair on the back
end, and then verify the relationship has Referential Integrity enforced and
is set up to auto-create the join. Then compact/repair the front end. It is
still doesn't work, you could delete the linked tables from the front end,
and linke them again, then copy the SQL statement into a new query and see
how it shows. Also, make sure it's not a permissions issue (Access security,
or Windows rights on the folder/file.) Realistically, this is a bit of work
for something that probably doesn't really matter much.

HTH

 

[Bob Darlington]

Thanks Allen,
I guess I just get nervous when things don't go the way I expect.
But I'll take your advice and not worry about this one.

--
Bob Darlington
Brisbane

Hi Bob

The absence of the one-to-many symbols in query design should not make any
practical difference to how the query runs. Sometimes Access is able to
figure it out; sometimes it cannot (e.g. if the table is aliased.)

If you want to try to solve this, you could try a compact/repair on the
back end, and then verify the relationship has Referential Integrity
enforced and is set up to auto-create the join. Then compact/repair the
front end. It is still doesn't work, you could delete the linked tables
from the front end, and linke them again, then copy the SQL statement into
a new query and see how it shows. Also, make sure it's not a permissions
issue (Access security, or Windows rights on the folder/file.)
Realistically, this is a bit of work for something that probably doesn't
really matter much.

HTH