'Moving' links in queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have areally bizarre one here...

I have a Referential 1-many link in a DB between primary and foreign ID
keys. Standard stuff. But in a query using this, after some use the link
mysteriously disappears and is replaced by an ordinary link between the
Primary key and a date field in the foriegn table?! I keep recreating the
query, which restores the ref lunk correctly for awhile, but after uses then
the link 'moves' again?

Has anyone experienced this behaviour before. In 15 years of Access I havent
seen anything like it and I'm at my wits end. I'm using Access2000.

Thanks.
 
You have a query that shows 2 tables, with a join between them, and
Access--all by itself--changes the query so the join is now on the wrong
fields?

If so, it sounds like some kind of corruption/confusion in the database. The
first suspect would be Name AutoCorrect. If you have not yet unchecked the
boxes under:
Tools | Options | General | Name AutoCorrect
do so now, and then compact the database.

If this does not fix the problem, switch the query to SQL View, and post the
before and after versions of the SQL statetment, with an indication of which
is the primary table in the relationships.
 
Thanks Allen but I've now realised what was causing this strange behaviour,
(if not how).

The foreign table was called 'Reports', which is of course a reserved word.
I've changed it to something else and this 'moving' or 'jumping' of joins
seems to have stopped. One for the archives!
 
Back
Top