automatic dublicate

[Irene Kral]

Hi folks, hope you can help me out.

I am working in a small private school and we have a DB for studentsdata,
classes, etc.
I wonder if there is some way to create an automatic "dublicate" for a
record as long as lets say last name and father's name of a new student are
the same as of one old student.. In that case we could assume that this
child is a brother or sister of some already in the DB existing student and
that's why i want to be filled in automatically home adress etc.
I thought that maybe it would be nice to have an alert which asks if it
really somebody's brother or sister or not.

In case you solved some similar problem, pls let me now.

thanks

irene

 

[Steve Schapel]

Irene,

You can use an Update Query for this. The details of how to set it up
will depend a bit on how you want it to work, but it will certainly be
possible.

 

[bob]

You can separate addresses into another table and assign unique keys to them
(the key, perhaps, including last name or something else that makes
sense)..then use the key to link the table to the other .(one to many)

That way, if someone's address is corrected, for example, the data has to be
entered only once.

That takes advantage of Access's relational capabilities and makes your life
easier.

Bob