Hi clever people
I know this is a bit of a cheek so I’ll apologise in advance
Sorry;-)
Ok As a retirement project I’ve taken on a Cemetery Database that need updating.
From my previous posts I have discovered that the Database is controlled by an exe written in VB or C++
So it seems to me that it’s best to “start” from Scratch and get rid of the EXE part as I have no access to the code – and wouldn’t understand it anyway!
The two tables seem to contain duplicate fields which seems pointless in a relational database
The criteria I have is
Each plot name is unique
Grave numbers are not unique and may be repeated across plots
Deceased names are not unique
Memorials are not unique to one single Grave
Each grave can have multiple occupant’s
Each grave can have multiple memorials
So I’ve spent the day surfing the web and youtube and discovered linking tables and I’ve come up with the attached plan
Is this viable and will all 39201 records have to be re entered or can I do this using the two tables and just import the exisiting tables as below and still extract all the information needed?
Ie Search by name and show all deceased with that name
Search by grave and show all occupant’s and all memorials for that grave.
search by memorial and show all related graves
Really do appreciate the help
Regards
Ian
Graves Table 39201 records
Mlink Plot Graveno Links Surname Forenames DayOfDeath MonthOfDeath YearOfDeath DayofBurial MonthOfBurial YearOfBurial Age Inscription PP Notes
Memorial table 17861 records
Plot Links GraveNo Mlink Inscription