Updating tables automatically

[Guest]

I am building my database off of one main table. From this table i have run
Make-table queries to display the information that i want, from there i make
corresponding reports. I made a form to input data into the master table,
but i need the information that has been edited, or new information for that
matter, to be updated automatically in the tables i created from the make
table queries. I created one to many relationships between all of the sub
tables and my master table and selected the option to cascade the changes but
that doesn't seem to work.
The ultimate goal would be able to enter information into my form and print
the corresponding updated reports, all from a switchboard without having to
rerun my queries. Hopefully i have made myself clesr enough. Help......
please.

 

[microb0x]

The first question I would have is why do you need to maintain both
ways of storing the data? One you normalized the single table into a
relational database why do you need to keep the single table?

If you want to keep this current approach you could build a save button
on your form and use code or a macro attached to that button to delete
your relational tables with query(s) then re-run your make-table
queries after deleting. This should get you the end result you are
looking for with the data.