So the example is three tables:
- Projects: each projects has a number of documents and tags
- Documents: a list of documents associated with a specific project
- Tags: a project-specific custom set of tags that can be applied to documents
1:N relationship between Project records and Documents/Tags Records, but N:N relationship between Documents and Tags.
Currently I have a model-driven app, in which the user selects a project and can view the Documents and Tags through tabs of that form. The tabs display the selected view for the table.
I am trying to figure out, for example, when the user is viewing the Documents, how to show that user all of the Tags that is associated with each of the Documents without requiring the user to click into the specific record to open the form that can show the tag as a subgrid. Ideally, the user would be able to add tags to a document in the same place, but I assume this is not possible.
I'd really like the document view to show something similar to a Microsoft List tag column or a Choices Column, where multiple tags can be viewed that are associated with the record. It's basically like a Choices column that changes depending on the project to allow custom user tags per project.
Any thoughts on how to do this? The only idea I had was to try to create some form of automation fills a text field with a list of tags each time a tag is added to a document. I assume you can trigger on the relationship table and programmatically amend a text field somehow.
Any thoughts?
