Recent content by cjc1867

  1. C

    Database Design on a Burial Register

    Hi Mike The burial register number is unique per person in the burial register so I would have thought the relationship between the 2 tables would be 1:1. Also, the address table's relationship is the wrong way round, as I will be using the same address a number of times. I will have a go...
  2. C

    Database Design on a Burial Register

    Hi I have got the genuine copy now so I will look at the database again that Mike kindly develop for me and see if it helps me remember what I did the last time. Most importantly, read through all these answers again. Thanks everyone for the help. Colin
  3. C

    Database Design on a Burial Register

    Hi Mike Thank you for creating the database for me, I have had a look and it looks great. My copy of Office is now saying that I don't have a proper licence, so I can only view it in read only mode. I need to get a genuine copy of Office before I can start using it. Colin
  4. C

    Database Design on a Burial Register

    Hi Pat I did reply to you earlier on and then managed to delete it as it got mixed up with another reply to Plog. I think the Reverend (Vicar or Curate) would have his own address i.e. The Vicarage, Llandeilo and maybe the Grave would have it's own address i.e. Llandyfeisant church, but the...
  5. C

    Database Design on a Burial Register

    Hi I left some tables with only one real value as I wanted to expand or add more fields at a later date. The Grave Number table, I have renamed and called it Grave. Now, I can add the Grave Number as the Primary Key as it will be unique i.e. 1 to 100. Graves that aren't on the map but in the...
  6. C

    Database Design on a Burial Register

    Hi Mike As requested a copy of the database. Colin
  7. C

    Database Design on a Burial Register

    Hi and thank you for responding. I live in the UK. When my stepfather was buried, my mother said to the Funeral Director that she and my younger sister would be buried in the same plot or grave. To allow this, they made the plot at least 3 coffins deep, one for each coffin. So when my mother...
  8. C

    Database Design on a Burial Register

    Hi I haven't designed nor built an Access database in 20+ years. Last time was at Uni, so now I am struggling. I would like to get a working model in Access and then see if I can convert it to a format that can be used in a WordPress website i.e. mySQL and PHP. Just wondering if anyone could...
See more
Top Bottom