Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Updating tables automatically

Discussion in 'Information Technology' started by Economics, Jul 28, 2006.

  1. Economics

    Economics
    Expand Collapse
    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.
     
  2. Loading...

    Similar Threads Forum Date
    India 11 Constables Get Pregnant at Training School Breaking News Apr 26, 2011
    Warm Up with Winter Vegetables (Vegetarian Casseroles) Cooking & Recipies Feb 7, 2011
    India Two constables arrested for beating, extortion Breaking News Jul 27, 2010
    History Cleaning Out the Augean Stables Punjab, Punjabi, Punjabiyat Aug 25, 2009
    Sikh News Cold weather damages sugarcane, vegetables in Punjab (New Kerala) Breaking News Feb 1, 2008

  3. microb0x

    microb0x
    Expand Collapse
    Guest

    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.



    Economics wrote:
    > 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.
     

Share This Page