+ Reply to Thread
Results 1 to 9 of 9

Thread: Access 03 Adding updating data from child table to Parent

  1. #1
    Barn Regular nboscaino is an unknown quantity at this point nboscaino's Avatar
    Join Date
    Jul 2008
    Location
    Philadelphia, PA
    Posts
    97
    Rep Power
    4

    Access 03 Adding updating data from child table to Parent

    I understand that the child table is the many table and the parent table is the one but I would like to tally up a field on many records on the many side (perhaps the last 20 records) and then import this number to the parent table. This number will then render the parent record searchable by that criteria.

    written another way I want to judge the parent record by immediate past performance instances. I am pretty sure that this will need to be code. I am a newby.

  2. #2
    Lightning Master AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123's Avatar
    Join Date
    Mar 2008
    Location
    Fortress Of Solitude
    Posts
    394
    Rep Power
    7

    Welcome to the Forum,

    I'm not exactly sure what your asking,. which is fine.

    Can you give me an better idea of what you are trying to acheive by advising your table structures

    I.e Parent Table and Child Table fields,

    Once i understand this we can work out how a relationship can be set.
    If i helped you, make me famous by clicking the

  3. #3
    Barn Regular nboscaino is an unknown quantity at this point nboscaino's Avatar
    Join Date
    Jul 2008
    Location
    Philadelphia, PA
    Posts
    97
    Rep Power
    4

    well I didnt think you would have gotten back to me so fast. Thanks alot. Ok well lets just call the parent table a contact table and the child table a calls table. There will be a many relationship obviously on the calls table. lets just say one contact has been called 10 times. I want to take information from each of the call records, work it in a mathematical formula, and then update the parent table (the contact) so that I can search all the contacts by that criteria. Can that be done?

  4. #4
    Lightning Master AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123's Avatar
    Join Date
    Mar 2008
    Location
    Fortress Of Solitude
    Posts
    394
    Rep Power
    7

    Quote Originally Posted by nboscaino View Post
    well I didnt think you would have gotten back to me so fast. Thanks alot. Ok well lets just call the parent table a contact table and the child table a calls table. There will be a many relationship obviously on the calls table. lets just say one contact has been called 10 times. I want to take information from each of the call records, work it in a mathematical formula, and then update the parent table (the contact) so that I can search all the contacts by that criteria. Can that be done?
    Yes,. can be done with relative ease,. i have a few things to do,. but when i get 15 minutes i'll knock up a basic sample for your viewing,. this will help you understand the basic principles a little better, and we can go from there.
    If i helped you, make me famous by clicking the

  5. #5
    Lightning Master AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123's Avatar
    Join Date
    Mar 2008
    Location
    Fortress Of Solitude
    Posts
    394
    Rep Power
    7

    Hi,

    Please see the attached basic sample.

    I'm not sure how much of this you undertand, so for the moment i'll let you take a look and ask questions on areas concerning you.

    thanks AOG
    Attached Images
    Attached Files
    If i helped you, make me famous by clicking the

  6. #6
    Barn Regular nboscaino is an unknown quantity at this point nboscaino's Avatar
    Join Date
    Jul 2008
    Location
    Philadelphia, PA
    Posts
    97
    Rep Power
    4

    I appreciate your help. I have been frustrated. I have spent a small fortune on books and am now at the point where I dont know where to go next. This forum seems to be a God send. I am somewhat familiar with many aspects of access now but am having trouble pulling them all together. Do you know of perhaps a good textbook where it gives someone assignments to just make a sample database tables queries and forms etc. I think that all my books are exhaustive on the sujects and reference oriented, making them dry and leave little room for experience by actually building a database. Necessary as they may be, I was hoping for a good compliment that would give me exercises and actually build some databases. I am going to copy all that about the book into a new thread because I think subsequesnt people might enjoy any answers I get.

  7. #7
    Barn Regular nboscaino is an unknown quantity at this point nboscaino's Avatar
    Join Date
    Jul 2008
    Location
    Philadelphia, PA
    Posts
    97
    Rep Power
    4

    I can see that your thumbnail has a relationship and that it is not one to many. The fields seem to be right. I dont know where i would go from there.

  8. #8
    Lightning Master AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123 is a jewel in the rough AOG123's Avatar
    Join Date
    Mar 2008
    Location
    Fortress Of Solitude
    Posts
    394
    Rep Power
    7

    Did you look at the attached working Ms Access Example? Look under the image thumbnail
    If i helped you, make me famous by clicking the

  9. #9
    Barn Regular nboscaino is an unknown quantity at this point nboscaino's Avatar
    Join Date
    Jul 2008
    Location
    Philadelphia, PA
    Posts
    97
    Rep Power
    4

    no sorry ill do that now. I am new to forum life so be patient with me as you have and thank you.

+ Reply to Thread

Similar Threads

  1. Create History Table / Outcome results
    By Rebelle in forum Database Design Help
    Replies: 11
    Last Post: June 10th, 2009, 11:54 AM
  2. adding numbers
    By todd2006 in forum JavaScript Programming
    Replies: 2
    Last Post: July 3rd, 2008, 02:38 PM
  3. Replies: 5
    Last Post: June 25th, 2008, 09:07 AM
  4. Database not updating
    By richyrich in forum .NET Development
    Replies: 5
    Last Post: June 3rd, 2008, 11:52 AM
  5. Help with Updating field
    By Rebelle in forum Microsoft Access
    Replies: 5
    Last Post: April 1st, 2008, 07:45 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

SEO by vBSEO