Parent - child help (RoR & MySQL)


#1

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!