I am new to access and all of this and trying to create a database to record livestock (budgerigars) I have put in the reletive informnation for 2 generations but would like to beable to click on a record in forms view and for the grandparents to be automatically inserted. Something like a family tree.

Also I would like to be able to double click on a entry which shows as a parent in a form view, and for the database to go directly to that entry and bring it up onto the form.

I hope someone can help and that I'm making so sense

(anyone know a good book that would help me understand all of this)

Thanks

Norma

http://www.amazon.com/Access-2007-Bible-Michael-Groh/dp/0470046732