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

Hopefully very simple relationship/table/form question

Discussion in 'Information Technology' started by al_mac75@yahoo.com, Nov 13, 2005.

  1. al_mac75@yahoo.com

    al_mac75@yahoo.com
    Expand Collapse
    Guest

    I have a hopefully very simple question for a problem that I haven't
    been able to work out. I have a very simple database to record client
    accounts and therefore have a table called Accounts. I have one client
    that needs some additional information populated every time a new
    account record is added. The simple way to do this would just be to add
    these fields to the Accounts table; however, I am really looking for a
    way to do this so that the information is only added for this
    particular client and is always added an any new records. I have set up
    another table but can't figure out how to format the realtionship so
    that the information from the Accounts table feeds into the new table.
    Can anyone assist ?
     
  2. Loading...


  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    "al_mac75@yahoo.com" wrote:

    > I have a hopefully very simple question for a problem that I haven't
    > been able to work out. I have a very simple database to record client
    > accounts and therefore have a table called Accounts. I have one client
    > that needs some additional information populated every time a new
    > account record is added. The simple way to do this would just be to add
    > these fields to the Accounts table; however, I am really looking for a
    > way to do this so that the information is only added for this
    > particular client and is always added an any new records. I have set up
    > another table but can't figure out how to format the realtionship so
    > that the information from the Accounts table feeds into the new table.
    > Can anyone assist ?


    The Accounts table really shouldn't "feed" the new table - that would imply
    that you're storing data redundantly, always a bad idea. For that matter if
    you're adding *the same* information every time, that's redundant too!

    If the information is related to Accounts but only to one (or a few)
    accounts, you have a good example of "subclassing" - the one common reason
    for the otherwise rare one to one relationship. Make your new table with the
    AccountID (the primary key of Accounts) as its Primary Key, and create a
    relationship joining Accounts.AccountID to this primary key. Access will make
    it a one to one relationship. You can set the Default Value property of any
    of these fields however you like, and put a subform on the form where you
    enter account information. Entering any data into the subform will create a
    new record in this table.

    If this isn't clear, please post back and explain the nature of this data
    and why you need a new record for every account.


    --
    John W. Vinson[MVP]
     
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