Someone recently requested an example of the above type of database. I knew there was a thread within the forum somewhere, as I remember contributing to it. It is an excellent example by pat Hartman here: (http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=54924)

Thanks a bunch!