The database I have relies on downloading data which is imported into tables based on a date range that I select from the external source of information. These txt files are imported on a daily basis and usually result in duplicated information due to the date ranges involved. So for example when I import people involvements I use the method of importing into the ImportPERINV table which stores duplicated info, then I run an update qry and append the data to the PersonTable which has the PK on CNI which is a unique number already created from the imported data from the external source. I then delete the content of the ImportPERINV table with a delete qry to enable new data to be imported the next day. These steps are contained in a macro.
The individual people in PeopleTable are then linked to other tables to record certain information regarding their activities, previous events history and vehicles. The narrative table stores a memo to enable me to create news letters for distribution.
Attached is a pic of the relationships to get an opinion before moving on to further questions. I'm sure there would be design faults so far, and I would appreciate any advise on a better design.
Well I'll start by saying enforce those relationships!!
Isn't this already up and running? I'd be very reluctant to change anything if it's currently working.
There are many things I'd want to change with that design, such as...
* consistent naming - why not tblCategories etc
* clear naming - wtf is Suburb2... what is CNI ... what is Client.Target etc
* elaboration of ID field names - CategoryID instead of ID etc
* enforce relationships ... for many reasons
* ensure every table has a primary key
... but the nuances of your application might make it tricky to make such changes.