To explain it clearer, I want to replicate doctolib.de where the input box does not only return the autocomplete for health problems but also the doctors' specialty and their names.
For the first one, I saw your guide on joining:
But I think it combines 2 entries into 1, instead of appending the list (hopefully I'm mistaken).
And for the second method, If what you mean is the views folder in database manager, I don't see any option to create a 'view'. just to collapse and expand all. maybe due to docker + node.js setup? I don't really know