How to update list autocomplete values ​​when adding them to the table they come from (Libre Office Base)?

Question

libreoffice

How can I force the autocomplete list values ​​to be updated when these values ​​are added to the table from which they are taken by the query? I'm not sure that I'm using the term "autocomplete" correctly, since the list only implies a choice from ready-made values)
There is a form in the database on the Libre Office Base.
Everything is simple there: 3 tables: the
"movies" table, the "tags" table, and the "movies-tags" table, between which there is a many-to-many relationship through the "movies-tags" relationship table, where a correspondence is established between the IDs of films and tags .
The form is needed to add films, add tags to them from the available tags and at the same time replenish the list of tags if the right one was not found.
Movies hang in the table with the possibility of adding. To add tags, there is a dependent form with a table and a single field of the "list" type, in which values ​​are pulled up for autocompletion using a sql query from the "tags" table. Also on this form, for convenience, there is a table of tags (it is not subordinate to any of the previously listed forms). And the problem arises when I add a new tag to the "tags" table (independent) and want to see it in the list of adding tags for the movie (the one with auto-completion through a query to this very tags table), but it does not appear there :(
Apparently, the request for autocomplete is made only at the moment the form is opened, and if I change something, it is not done a second time. Thus, to add a freshly added tag to a movie, I have to reopen the form. It can be fixed? Is it possible to force a list with auto-completion through a sql-query to force this list of values ​​to be updated either with changes in the "tags" table or, at worst, by some button that can be added to the form, or by an event? Or maybe there are some easier solutions?

Answer 1

I found a good solution:
In the form navigator, select a form with a table where autocomplete data is pulled.
Add a button to it and specify the button type in the button properties: "Update form".
Now, when updating the "Tags" table, you can click on this button and the data will be updated.
PS: if someone knows how to automate this, please share.