A Link to the Reference Table Past
August 11, 2010 11:10 AM Subscribe
MS Access question. I have a table of references and a query that returns case numbers. Another table lists the references and case numbers that are linked to each other. I need to find a way to list the references for each case that are NOT linked to that case. Difficulty level inside.
posted by charred husk to computers & internet (6 answers total)
The query gets its list of case numbers from another database, and depending on the criteria may change from time to time. Because of this, the link table is a record of connections only.
Essentially, I need to be able to list each reference for each case minus the pairs that are already matched in the link table. Either due to fatigue or lack of knowledge, I haven't been able to figure this out.
Access version is 2007 but it has to work with 2003.