Another newbie question I fear but help as always appreciated.
I have a tools table and a controls table and for each 'tool' I allow
user to specify upto 3 controls.
So the Tools table is :-
and the Controls table is:
I have linked the tables in their models with
When I display the Tools rows I want to display the 'desc' column from
the Controls table for each of the control_id1, control_id2 and
Is this possible or is a relationship link only available on a single
column in the Tools table that must be called 'control_id' ?
Hope this makes sense.