Show only related values starting from Clients. Showing all shows everything.
I did that but nothing came up
I think this has to do with how your relationship is setup. I am not sure exactly how you want it, but it seems you may not be properly relating the content to the client. I am assuming one client can have many contents and no one content will have more than one client associated.
If you insist on having this actions table in the middle you may want to have a duplicate table of both clients and content and relate them for a VL. Clients::_kp_clients_id = Content::_kf_clients_id. I would have this setup this way and just have a table for actions as a VL to populate a field in the Content table but again I do not know what you are doing exactly.
Just to be clear actions would be an unrelated table that holds values for the list.
Your assumptions are correct 1 client can have many contents but each content has only one client.
My problem is that I don't just have content, I have events and other things that all have actions
I also have a portal in the clients record that shows relevant actions to that client. and if I move the actions to the other side of contacts it will effect the portal.
I have tried having a separate occurrence of clients and content but that didn't work either.
maybe I can create a list with a script? any ideas?