Hi I've tried searching the Net for this but not come across any useful answer. I have just taken over several existing databases which I need to tidy-up / upgrade - whatever you can think of. After some investigation I realise that no table relationships have been defined whatsoever. However, all the "relationships" (implicit ones) are "defined" through the VBA code. Why is this? Why have no table relationships explicitly declared? Was it bad design practice? As far as I know - every database I've ever built or worked with has had table relationships declared! Referential integrity and all that!
Thanks for your help.