I''m having some trouble getting a parent-child relationship working. I''ve got 5 tables, 1 being the main table and 4 being lookup tables for the main. in the chart below, each of the xxxx_id fields has a corresponding table. I would like to be able to show just the result of the relationship. this is also outlined below. table_example: [id_of_object] object_id region_id state_id vendor_id other_info | | | | | | | | | | | | / \ | / / --------- | ---------- / \|/ id object same as object what should show on display: (id_of_object) object region state vendor other_info Thanks! -- Posted via http://www.ruby-forum.com/.