I'm not very experienced with Access but have created a db for my travel business, however along the way I've made a few errors which I'm trying to put right.
One being that I never set enforced referential integrity between some primary and secondary tables. So for example I have a [Quotes_Table] which is the primary, which then has several secondary tables eg. [Flights], [Hotels], [Car_Hire] etc.
Over the last year or so, quotes have been deleted, but this has left all the related data in the secondary tables and it's getting full of old data which I need to clear. Also it now won't let me enforce referential integrity because of this data in the secondary tables which doesn't relate to a quote.
All the flights, hotels, Car_hire etc have a primary key [Quote_Ref] which then links it to the quote, so is there a way to use this to find rows in the secondary tables which doesn't have a related quote in the Quotes table?
Hope this makes sense and hope someone can help.. thanks in advance.
Gav