Unableto Add a new record

[Jen0dorf]

Morning Ian, I'm in work and was stuck on the m56 last night so I've not had/got a lot of time to look into this. I don't think you need a join table at all.
an example of structure:

deceased - all info about the dead guy.
memorial (more than one for a dead person) - info specific to that single memorial... ALSO this is the important bit.. a foreign key relating to the deceased table.


so that one record in deceased.. has multiple records elsewhere that use its FK to combine all the data.

hope this makes sense. ask away.

Hi

as usual I'm a bit lost but

the tblgraves is one to many because each grave can contain multiple bodies

tbldeceased contains all the details relating to one deceased person

So table graves is one to many with tbl deceased.

tblmemorial are memorials which link to tblgraves and as each grave can contain several deceased each grave can have several memorials.

To further complicate matters it a husband and wife are buried in two locations there may be a single memorial on one of the graves and nothing on the other.

It's all confusing and I'm still not sure I've got my head around it.

I'll have another look this evening

thanks



Ian

[Homegrownandy]

one grave = many deceased
many deceased = many memorials (husband and wife may have two)

that's what I get from your posts. Where are memorials located? on a grave plot?

so you have a list of plots... assign a memorial and a deceased?

correct anything that's wrong.