G
Guest
Hi folks,
I am setting up a database for my church. I have a table with contact
details and other key data on, but also want to use the database to track
attendance. Is it better to have the dates of the Sundays of the year in the
main table (this seems a bit clumsy to me for some reason) or to set up a
related table with those dates on (with a yes/no response needed). If I set
up the separate table how do I get the names from the first, contact table,
into the second and to keep the second updated from the first. A "look up"
function seems to be rather cumbersome with over 60 names on the database.
ta
Andy
I am setting up a database for my church. I have a table with contact
details and other key data on, but also want to use the database to track
attendance. Is it better to have the dates of the Sundays of the year in the
main table (this seems a bit clumsy to me for some reason) or to set up a
related table with those dates on (with a yes/no response needed). If I set
up the separate table how do I get the names from the first, contact table,
into the second and to keep the second updated from the first. A "look up"
function seems to be rather cumbersome with over 60 names on the database.
ta
Andy