Displaying 1 result from an estimated 1 matches for "case_managers_placements".
2006 Feb 06
3
linked table confusion
...arse_func.c L1359 Runknown_attribute: SELECT * FROM
case_managers WHERE (case_managers.placement_id = 4) LIMIT 1
which makes sense in that I don''t have a ''placement_id'' column in
case_managers table. But case manager has many placments so I did create
a join table - case_managers_placements in which there are 2 fields...
placement_id
case_manager_id
and foreign keys for both fields to their respective tables
then I inserted 1 record, for the placement with the proper placement_id
and case_manager_id for the join...
I still get the above error.
How does one work through this situatio...