I have an excel flat file with about ~6k records I want to put into a MS Access database. The original Excel fields are:
Name Address City State Zip DOB CaseNumber DateSentenced AmountDue
I saved everything in the Excel file into smaller text files by column like:
NAMES id last first middle suffix ADDR id line1 city state zip BDAYS id dob CASENO id casenumber courtnumber SENTENCED id datesentenced AMOUNTS id amountdue TOAGENCY id year
I imported each of these into an Access table and made sure they had no errors.
So far I have relationships set up like:
Each one has Enforce Referential Integrity & Cascade Update checked.
My problem is that the flat file had many duplicate names, addresses, dobs for a different case number; since one person can have many cases.
How do I fix this without making the universe implode? I'm extremely new to this kind of thing & don't know what question to ask :(.