So, I have a (very large) master table of something, say items in my household, and then I have different views of that table, say for each room a list of the items in that room (in this example I would have a column “room” and the view would use a filter on this).
Now, I might need to manually add (i.e. type) a new item directly in one room. Say “blue vase” in “living room”. If I start typing “blu…” I get suggestions, and one is the “blue vase”. (Oh, right! I added that before!) But since it is not yet in the “living room” view, apparently I forgot to tag it as “living room” in the “room” column. If I select the suggested “blue vase” from the auto complete, however, it will not pull the existing “blue vase” entry into the new view, but rather create a new entry “blue vase” with the “living room” label, which is obviously not what I want.
How can I pull the already existing entry into the current view of the table (i.e. only add the filter criteria and not create a new row)?
I can, of course, go to the master table, look for the entry and add the filter criteria there, but that’s not what I want. I want to do it directly in the view while I am typing it. Is that possible?
I wasn’t able to find a solution to my question, because I’m not really sure how to effectively search for it. (As you see my explanation became rather long…) So, I apologize for asking this again, if it was answered before.