G
Guest
I have two tables, one for parents and one for children. Each table has a
field for the surname. I am trying to store two surnames in the event they
are different, one for parents and one for the children. There is a one to
many relationship linked by a phone number field. As new children are
entered I would like to have the parents surname prefilled so, during data
entry, the surname doesn't have to be reentered in the event it is the same.
I've seen similar postings for saving calculations with the suggestion to
simply use the calculation and not store the data. The only way I can think
of to take this approach is to have some kind of statement that checks the
data in the surname field from the children's table and display the surname
from the parent's table in the event there is no surname entered in the
children's table otherwise display the data from the children's table. I
haven't the faintest clue as to how to do that.
Any suggestions?
field for the surname. I am trying to store two surnames in the event they
are different, one for parents and one for the children. There is a one to
many relationship linked by a phone number field. As new children are
entered I would like to have the parents surname prefilled so, during data
entry, the surname doesn't have to be reentered in the event it is the same.
I've seen similar postings for saving calculations with the suggestion to
simply use the calculation and not store the data. The only way I can think
of to take this approach is to have some kind of statement that checks the
data in the surname field from the children's table and display the surname
from the parent's table in the event there is no surname entered in the
children's table otherwise display the data from the children's table. I
haven't the faintest clue as to how to do that.
Any suggestions?