AnsweredAssumed Answered

Relationship nightmare

Question asked by weedonpaul on Nov 11, 2015
Latest reply on Nov 11, 2015 by weedonpaul

OK this will be as clear as mud

 

I have a table called clients with details about our clients

 

for our clients we do many things organise events (table called events) write press releases and articles (table called content) etc

 

I have a portal on my clients layout to Actions, actions are a list of jobs that need to be done some are linked to events and some to content

 

I have a button on my clients page to add a new action I eventually want this button on multiple pages

 

I want to create a new action by first asking weather it is an event action or a content action for this I have written a script which works.

 

once I know whether it is an event or a content related action I want to look through the list of events or content that relate only to that client and then assign that action to that event or content.

 

relation ships are as follows 

Clien::clientID = Actions:clientID

Actions::ActionID = Content:: action ID

Actions::ActionID = Events:: action ID

 

I'm not sure this is right - each event/content can have many actions but if I use eventID and ContentID and Many other JobsID it becomes unworkable.

 

I have it all working except I get a list of all content/Events even those not related to that client. I am  worried I've got down a wrong path so would be interested to here how others would solve this problem?

Outcomes