K
Karen
Hi
I have a Form that is designed using a tab control. Page 1 of the tab
control is of benefactors, page 2 of the tab control is of the deceased.
Basically, when benefactors call they do so to request prayer for the
deceased. Therefore, their name is added and the deceased person is added
(fields included on each page respectively) which is then added to the table
that is the record source. (both deceased and benefactor are in one table)
Question #1 - Based on the above, if more than one deceased is added for
each benefactor, the table is not repeating the benefactor name in the new
line its creating for the deceased, and therefore, it is not linked to the
correct benefactor. How do I fix this?
Once part one above has been added, the person that is assigned this "job"
to actually facilite the prayer for the deceased, is then assigned using a
"Worker Form". Their name is picked from a search List Box included on the
form and there is a subform with all the different prayer options in which
the user picks the prayer and selects SAVE to save the record. The record
source for this table is called "worker"
Question #2 - After I enter the deceased, I need to add a control to
immidiately jump to the Worker form, do as I described above for the worker,
and then when I select save, magically have the benefactor connected to the
worker which I then need to report on and keep track of. Make any sense??
If so, how do I do this?
(I should also mention that the form and subforms on this worker form are
linked in the relationship window and this part of the form is working
wonderfully,,,, just need to link the yungeleit to its benefactor.
In addition, question 2A - I need the ability to sometimes assign more than
one worker to a benefactor... so I may need to select a benefactor, select
the prayer, select save and before exiting the form, repeat the process using
different workers.
Can this be done?
By the way, using Access 2003
Thank you!!!
I have a Form that is designed using a tab control. Page 1 of the tab
control is of benefactors, page 2 of the tab control is of the deceased.
Basically, when benefactors call they do so to request prayer for the
deceased. Therefore, their name is added and the deceased person is added
(fields included on each page respectively) which is then added to the table
that is the record source. (both deceased and benefactor are in one table)
Question #1 - Based on the above, if more than one deceased is added for
each benefactor, the table is not repeating the benefactor name in the new
line its creating for the deceased, and therefore, it is not linked to the
correct benefactor. How do I fix this?
Once part one above has been added, the person that is assigned this "job"
to actually facilite the prayer for the deceased, is then assigned using a
"Worker Form". Their name is picked from a search List Box included on the
form and there is a subform with all the different prayer options in which
the user picks the prayer and selects SAVE to save the record. The record
source for this table is called "worker"
Question #2 - After I enter the deceased, I need to add a control to
immidiately jump to the Worker form, do as I described above for the worker,
and then when I select save, magically have the benefactor connected to the
worker which I then need to report on and keep track of. Make any sense??
If so, how do I do this?
(I should also mention that the form and subforms on this worker form are
linked in the relationship window and this part of the form is working
wonderfully,,,, just need to link the yungeleit to its benefactor.
In addition, question 2A - I need the ability to sometimes assign more than
one worker to a benefactor... so I may need to select a benefactor, select
the prayer, select save and before exiting the form, repeat the process using
different workers.
Can this be done?
By the way, using Access 2003
Thank you!!!