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!