This is a good case for why we create relational databases. You may want to consider doing that with your database if you have not already. Making sure you have cascading updates and deletes may help with this. Also ensuring that you force certain fields to contain data so that someone cannot skip entering data. You will get more advice on this I am sure. I am NOT a dba but these are some of the things that I do in creating new databases.
Bruce Sorge -----Original Message----- From: Steven Sprouse [mailto:[EMAIL PROTECTED] Sent: Friday, July 21, 2006 1:12 PM To: CF-Talk Subject: Re: data not being displayed you hit the nail on the head with looking closely at the data. The person who typed this data in left out all of the prin and vprin data out for the schools and centers. So it wasn't coming up because there was no school code in the prin and vprin table to match up to. It takes some stupidity to learn something I guess....thanks for all of the help! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247351 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4