Sounds like you may want to update your table structures to be better
normalized to handle your data so that you eliminate duplicate data.

I would probably create some type of "household" or "family" record the links
the siblings and holds the shared address, phone email, etc



John_In_Northern_California wrote:
I'm the registrar for a Little League and I track all of the information
about players, coaches, sponsors, etc. When I come across an instance where
siblings are playing, I would like to create a new record and "autofill" the
input form with some of information (address, phone email, etc.) from a
sibling's record by using a single "Add Sibling" button. Thanks for any help -
John

--
Boyd Trimmell
aka HiTechCoach
http://www.hitechcoach.com
http://www.officeprogramming.com

Message posted via http://www.accessmonster.com