Actions::ActionID = Content:: action ID
Actions::ActionID = Events:: action ID
This does not look right. An action belongs to Content or an Event, not the other way around; so an Event would never store an Action ID, nor would a Content record.
It is not clear to me where you are stuck (except the above). Are you struggling to display a list of Events for a given client so that the user can pick one to assign the Action to?
I've been giving it some more thought, I think I need to set up a unique ID in Actions that can be gotten from events/content or anything else.
because events/content etc can have many actions
I was doing it wrong in terms of one record trying to hold many action ID's
I'm going to try and sort that out then get back
does that make sense?
Sure, Actions need their own unique ID, but no: that ID should not be "gotten" from events/content. The link to and from Content to Actions is by the Content ID stored with the Action. Same for the Events.
Ok I've sorted out the relationship stuff to a point but have another question around it but think it will be easier if I start explanation again so will re explain it all in a new thread