I have created a new table view for customers, so that when they log in, they only see the information that they need to see...
I used the Query:
CREATE TABLE IF NOT EXISTS Customer( SELECT ColumnA, ColumnB, ColumnC, ColumnD, ColumnE, ColumnF, ColumnG, ColumnH FROM DB.Table )
The table populated with the expected results, however when the parent table gets new data added, the Queried table does not update.
Is there a recommended way to keep this table up to date?
Id rather not have to refresh the query every day as the table also has a
WHERE funchtion where I filter the a specific customer, as a result I have a number of the same queried tables in plac, lone for each customer.
Is there a way for this to automatically update?