5 Replies Latest reply on Nov 12, 2015 12:33 AM by weedonpaul

    Value lists

    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

       

      content---<actions>---Client

       

      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?

       

       

      Specify_Fields_for_Value_List_“Content_Title”.jpg

        • 1. Re: Value lists
          bigtom

          Show only related values starting from Clients. Showing all shows everything.

          • 2. Re: Value lists
            weedonpaul

            I did that but nothing came up

            • 3. Re: Value lists
              bigtom

              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.

              • 4. Re: Value lists
                bigtom

                Just to be clear actions would be an unrelated table that holds values for the list.

                • 5. Re: Value lists
                  weedonpaul

                  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

                   

                  Content--------------<

                   

                  Events----------------<action>------------------Clients

                   

                  Other-------------------<

                   

                  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?