[AccessD] duplicates question * can't find in archives

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."



More information about the AccessD mailing list