How to create a detail and / or results page that displays content from a multiple choice list
I would like to know how to create a detail and / or results page that displays content from a multiple choice list.
I have read your tutorial "Manage Relational Tables" and viewed pages from your example-site "Blue Sky Music". And from this, I think I understand how to create both an insert and update-page with a multi-choice list and using the "Manage Relational Table" command.
But I can not find any information, tutorial, example - on how to view the content from such a list. Neither the results page or products page from the above mentioned site contains this.
For simplicity's sake, could you explain how it is possible to show the results from the table "Genres" in the site "Blue Sky Music" - as a text with commas between each selection in the list on the detail page.
If I understand correctly, you have to create a recordset (RS) with Inner Join. But I do not really understand how this works.
I hope you understand what I mean.