Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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. OP
    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.
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page