How to refresh/reload a table without a form?

Win10 LO 7.4. HSQL2.51

Hi,

One of my split db starts off with a dialog which calls some sub which in turn creates a table prior to loading a menuform.
The freshly created table however does not show up in the table listing of the db window unless I click View Refresh tables.

image description

As a consequence when opening a form utilising this table an error message tells me that the table does not exist. Once clicking the message away and clicking another command button on the form the data from the table loads with no problems.

So how can I get base after the table creation via sql to get the table from the backend? Can not use the standard refrsh all table macro as no form is open at the time the table is generated.
Thanks for your thoughts.

Hello,

See code in edit section of answer here → refresh existing dbf database tables in a macro

@Ratslinger - Thank you!