Is there a way to automatically replicate rows in a table into another table in the same base? i.e. if i have one table set up, can I create a new one that is identical to the first and also automatically updates as new records are created in the original table.
I have the some query. Hopefully someone can give advice on this.