Reference to items in the same table
I am still new to the field of databases so sorry if this question is badly formulated.
I have a table 'Items' that lists a large number of items that can be associated to one another.
I want to have a field, like a multiple choice, where I can select all the items that are associated with the item in question.
For instance, in my table 'Items':
When working in the form of item 4, I want to have a drop-down box that shows all the items currently listed in my table 'Items'. From this box I want to select multiple items that are associated with Item 4.
Is there a way to do this?
Paul thank you for the swift reply.
So in the dynamic value property I refer to the table Items, whereas in the dynamic value name I refer to a certain field in the table Items, right? I tried to refer to the table under the dynamic values by writing Select Items but somehow I cannot save so I assume this isn't right?
Paul and Fred thank you both for the answers, it worked!
One more thing, if I make such a Dynamic MC, and I select a x number of items, is there a way to see certain fields of the selected items listed below (for instance the image of each selected item)? Similar like the lists you get when you select have a Table reference?