Baptism/Marriage/Funeral DataBase Issues

[Guest]

I didn’t know how to start and how to finish, but here goes;

I am building an Access Database to be able to record all the Church records
as follows;

a) Marriages
b) Baptisms
c) Funerals

What I have started to do (because I like the way it looks) is something
similar to the Issues Database;

I have a Contacts table and Form to load each and every individual that
might have any one or more of the above sacraments..

On each Contact Form there is a Tab for GENERAL, also Marriages, Baptism
and Funeral. I was hoping to add a link to identify this person as a parent
and/or child of another contact (but let me get to that version later).

As each time the Priest performs a Sacrament, the following information is
valid;

a) Date of Sacrament
b) Priest performing the Sacrament (because of the fact that we may
have the Bishop perform a sacrament at the Church or while our Priest is on
leave…)
c) Location/Church where Sacrament took place… because of the fact
that our Priest may perform the sacrament in a Country Church, or in the case
of a newborn baby that maybe dying (at the hospital)
d) Type of Sacrament

I have set up the table and Form for these items above.. Works
great….until…..

In the Form I have 3 tabs with Sub forms as follows;

** When the Mysterion (Sacrament) type is chosen – I have it as a drop down
list (I would prefer 3 Buttons that get locked once the Record is saved)

the idea is to have the SUB FORM come to the front (or really pop up in a
new window) and the remaining 2 subforms get locked or don’t show at all,
leaving comments at the bottom.

 

[Guest]

I didn’t know how to start and how to finish, but here goes;

I am building an Access Database to be able to record all the Church records
as follows;

a) Marriages
b) Baptisms
c) Funerals

What I have started to do (because I like the way it looks) is something
similar to the Issues Database;

I have a Contacts table and Form to load each and every individual that
might have any one or more of the above sacraments..

On each Contact Form there is a Tab for GENERAL, also Marriages, Baptism
and Funeral. I was hoping to add a link to identify this person as a parent
and/or child of another contact (but let me get to that version later).

As each time the Priest performs a Sacrament, the following information is
valid;

a) Date of Sacrament
b) Priest performing the Sacrament (because of the fact that we may
have the Bishop perform a sacrament at the Church or while our Priest is on
leave…)
c) Location/Church where Sacrament took place… because of the fact
that our Priest may perform the sacrament in a Country Church, or in the case
of a newborn baby that maybe dying (at the hospital)
d) Type of Sacrament

I have set up the table and Form for these items above.. Works
great….until…..

In the Form I have 3 tabs with Sub forms as follows;

** When the Mysterion (Sacrament) type is chosen – I have it as a drop down
list (I would prefer 3 Buttons that get locked once the Record is saved)

the idea is to have the SUB FORM come to the front (or really pop up in a
new window) and the remaining 2 subforms get locked or don’t show at all,
leaving comments at the bottom.

Questions that I have?



How do I set up an automatic female surname change when there is a Marriage
– That is Current… with the surname of the Husband…. (Status is Current, Non
Current, Error) I have included two Radio Buttons [ Male / Female ] in the
Contacts Form. Should I set up a Field in the Contacts Table to read the
Radio Button chosen and set the value of the table field to either Male or
female for easy use of name change.
Also how can we keep track of the Maiden Name in a second field in the Table
Record, called Maiden Name?
How do I make the [Marriage] button or choice of type not allowed if all
their previous marriages status haven’t been switched to Non Current
How do I limit the number of subform records for Baptism & Funeral to 1 only

How would it be best to attach the corresponding male Father and Mother to
an individual child? How would this be linked together, to be able to view
each persons children as a list and the corresponding mother or father of
that child?


THANKS HEAPS

 

[Guest]

I didn’t know how to start and how to finish, but here goes;

I am building an Access Database to be able to record all the Church records
as follows;

a) Marriages
b) Baptisms
c) Funerals

What I have started to do (because I like the way it looks) is something
similar to the Issues Database;

I have a Contacts table and Form to load each and every individual that
might have any one or more of the above sacraments..

On each Contact Form there is a Tab for GENERAL, also Marriages, Baptism
and Funeral. I was hoping to add a link to identify this person as a parent
and/or child of another contact (but let me get to that version later).

As each time the Priest performs a Sacrament, the following information is
valid;

a) Date of Sacrament
b) Priest performing the Sacrament (because of the fact that we may
have the Bishop perform a sacrament at the Church or while our Priest is on
leave…)
c) Location/Church where Sacrament took place… because of the fact
that our Priest may perform the sacrament in a Country Church, or in the case
of a newborn baby that maybe dying (at the hospital)
d) Type of Sacrament

I have set up the table and Form for these items above.. Works
great….until…..

In the Form I have 3 tabs with Sub forms as follows;

** When the Mysterion (Sacrament) type is chosen – I have it as a drop down
list (I would prefer 3 Buttons that get locked once the Record is saved)

the idea is to have the SUB FORM come to the front (or really pop up in a
new window) and the remaining 2 subforms get locked or don’t show at all,
leaving comments at the bottom.

Questions that I have?



How do I set up an automatic female surname change when there is a Marriage
– That is Current… with the surname of the Husband…. (Status is Current, Non
Current, Error) I have included two Radio Buttons [ Male / Female ] in the
Contacts Form. Should I set up a Field in the Contacts Table to read the
Radio Button chosen and set the value of the table field to either Male or
female for easy use of name change.
Also how can we keep track of the Maiden Name in a second field in the Table
Record, called Maiden Name?
How do I make the [Marriage] button or choice of type not allowed if all
their previous marriages status haven’t been switched to Non Current
How do I limit the number of subform records for Baptism & Funeral to 1 only

How would it be best to attach the corresponding male Father and Mother to
an individual child? How would this be linked together, to be able to view
each persons children as a list and the corresponding mother or father of
that child?


THANKS HEAPS