Well my latest problem has to do with queries. I have two tables I want to search they are related by location in a one to many fashion. When I run a query looking for all the records at a given location, I get the correct record from the parent table, but from the child I only get the first on that matches the criteria. All help is greatly appreciated. Thanks for all the help in the past and in the future.