Jump to content
  • 0

Table based list, multiple values




I have a table of topics. I have a table of tags. I want to associate one or more tags with a topic. I can use "List - String" and this does exactly what I want (I get a pop up when editing and can select multiple list values). How can I replicate this where tags is a table instead of a list?

I assume I need a 3rd table with TopicID and TagID with many-to-many relationships defined but I can't figure out how to get this to actually show the list in edit mode and save/update the entries. Any help appreciated.


Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Yes, you need to have a third table and then what you can do is to create a pre-defined report based on this third table which is filtered by Topic ID. Enable delete and inline insert on this tubular report, get the frame deploy code and place it in the footer of the details page of your Topic report. The frame has a source URL pass the ID of the Topic through this link so when you move to details of topic you only see associated tags.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...