is it possible to create a multiple choice field where the choice values refer to another table. In my case I want to add multiple keywords (which could be easily done with a multiple choice field) from a controlled vocabulary (which could be best controlled in a table). For now, if I want to use the multiple choice field I would have to add all the keywords from the rather large controlled vocabulary by hand. Direct table references do not appear as an option here, since I need to be able to add multiple keywords. Any ideas?
Not using the mulitple choice "field" type. You would need to create a relationship between two tables.
Thanks for the reply! If you mean simple references between two tables, I don't see how I could relate one record from table 1 to multiple keywords from table 2. Or do I overlook something essential here?
Are you looking for something like this? Master Row in Table 1 linked to multiple keywords ?
Create an association table between Table 1 and Keywords.
Yes, that looks very much like it! Could you share a link so I can have a more detailed look on how it's built? Thanks!
Thanks! That is surely helpful. The only thing then is, that the Keywords only appear in Form view of Table 1, so there is no way to search for the keywords. As far as I know one can only query data that appears in table view – but the column "Keyword Association" of table1 for some reason can't be included. (Although it appears as one of the "available columns" when I want to edit the columns - it just isn't clickable.) But if I can't display all entrys of table 1 that are tagged with a specific keyword this makes the keyword kind of useless for my purposes. Is there a way to display the keywords in a normal table view?
I am not following 100%... Here is a "view" that searches by key word and display's the Table 1 row text..
You can also configure the Keyword Association view on the Keyword table to show the Table 1 text.
To populate the Table 1 row with "Keyword" .. .you can also add a search of the keyword table and populate build the keyword association via code snippet in an after update trigger.. There are other threads in this forum that outline that approach..
Thanks again! But this is not quite what I am looking for. Maybe I should explain the context: My Table1 would contain many, many film titles and a lot of filmographic data. I then have a rather long list of index terms or keywords and I want to be able
1) to make connections between one film title and multiple index terms,
2) to manage my keywords within a table,
3) to search for a specific index term and get a search result in form of a table view that displays all the columns of table1, so I can at a glance compare most of the filmographic data of all titles that are linked to one specific key word. Ideally, I would be also able to combine this with filters in other columns.
As far as I understand this, 1) and 3) are made possible very easy by using a simple "multiple choice field" in the form of Table1. Apparently it is not possible to draw the choive values of such a field from another table, so I can't do 2) then. This would mean I would have to enter all my keywords by hand as choice values of the multiple choice field.
The solutions you suggested only fulfill 2), but I can't see how to achieve 3) then. It appears to me as if only a very small part of the information of table1 can be displayed in case of a keyword search, namely only the data that overlaps in table1 and "Keyword Association"; in your example this is the content of the column "Text" of "Table1", in my case this would be the mere titles, but not all the filmographic data that I would need to compare.