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!
on 2006-04-10 16:00