John Clark
John.Clark at niagaracounty.com
Tue Nov 16 12:30:59 CST 2004
I have been searching archives, but I can't find this yet... I am rewriting a DB that was originally done on a Unix box. I have imported their data and I am trying to make it fit my scheme. Their way (the old way) was to enter all information again and again and again. This DB is tracking residents going to school out of district (I guess there is some reimbursement from home county) and each semester they enter SSN, Name, School, etc.. I am making the student screen so that once the SSN, Name, & Address is entered, the rest is entered in a subform. So I think I need to take the current table and break it down into two tables. I will have to rid the student table of all dups and somehow link the other table...the new tbl_stntdata table...to the tblStudent table. How do I get rid of all the dups? Or can I? Maybe I'll just tell them that they'll have to go "day forward."