AnsweredAssumed Answered

Value lists

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

I currently have a table called clients with corresponding layout. I have another table called actions in which I store to do items and I have a mother table called Content


Content::ContentID=Action::ContentID  Action::ClientID=Client::ClientID




when adding an action I want to pull up a value list of Content that belongs to the client. everything works the I include all values, but I get all content regardless of client. I have tried using another table occurrence "Content list for clients" (will rename if it works) and that's

Content list for clients::ClientID=Client::ClientID

See below


That doesn't work and I can't think why, any ideas?