I have a table that populates specific data from a SQL view when I manually
run an append query - works fine.

What I really need to do is have that table populated automatically the
moment a new record appears in the view - hands-off on my part. How could I
best do this?