Go Back   DeveloperBarn Forums > Databases > Microsoft Access

Sponsored Links

Discuss "Access 03 Adding updating data from child table to Parent" in the Microsoft Access forum.

Microsoft Access - Microsoft Access is a database for small to medium applications. Learn tips and tricks and best database practices here.


Reply « Previous Thread | Next Thread »  
 
LinkBack Thread Tools Display Modes
  #1  
Old July 14th, 2008, 07:19 AM
Barn Regular

 
Join Date: Jul 2008
Location: Philadelphia, PA
Posts: 76
Thanks: 8
Thanked 0 Times in 0 Posts
Rep Power: 1
nboscaino is an unknown quantity at this point
Default 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.
Reply With Quote
Sponsored Links
  #2  
Old July 14th, 2008, 07:32 AM
AOG123's Avatar
Lightning Master

 
Join Date: Mar 2008
Location: Fortress Of Solitude
Posts: 93
Thanks: 6
Thanked 23 Times in 18 Posts
Rep Power: 1
AOG123 is on a distinguished road

Awards Showcase
Microsoft Access 
Total Awards: 1

Default

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
Reply With Quote
  #3  
Old July 14th, 2008, 07:41 AM
Barn Regular

 
Join Date: Jul 2008
Location: Philadelphia, PA
Posts: 76
Thanks: 8
Thanked 0 Times in 0 Posts
Rep Power: 1
nboscaino is an unknown quantity at this point
Default

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?
Reply With Quote
  #4  
Old July 14th, 2008, 07:43 AM
AOG123's Avatar
Lightning Master

 
Join Date: Mar 2008
Location: Fortress Of Solitude
Posts: 93
Thanks: 6
Thanked 23 Times in 18 Posts
Rep Power: 1
AOG123 is on a distinguished road

Awards Showcase
Microsoft Access 
Total Awards: 1

Default

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.
Reply With Quote
  #5  
Old July 14th, 2008, 08:39 AM
AOG123's Avatar
Lightning Master

 
Join Date: Mar 2008
Location: Fortress Of Solitude
Posts: 93
Thanks: 6
Thanked 23 Times in 18 Posts
Rep Power: 1
AOG123 is on a distinguished road

Awards Showcase
Microsoft Access 
Total Awards: 1

Default

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
File Type: jpg relationship.JPG (13.5 KB, 7 views)
Attached Files
File Type: zip Contacts.zip (31.9 KB, 2 views)
Reply With Quote
  #6  
Old July 14th, 2008, 08:50 AM
Barn Regular

 
Join Date: Jul 2008
Location: Philadelphia, PA
Posts: 76
Thanks: 8
Thanked 0 Times in 0 Posts
Rep Power: 1
nboscaino is an unknown quantity at this point
Default

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.
Reply With Quote
  #7  
Old July 14th, 2008, 11:46 PM
Barn Regular

 
Join Date: Jul 2008
Location: Philadelphia, PA
Posts: 76
Thanks: 8
Thanked 0 Times in 0 Posts
Rep Power: 1
nboscaino is an unknown quantity at this point
Default

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.
Reply With Quote
  #8  
Old July 15th, 2008, 03:02 AM
AOG123's Avatar
Lightning Master

 
Join Date: Mar 2008
Location: Fortress Of Solitude
Posts: 93
Thanks: 6
Thanked 23 Times in 18 Posts
Rep Power: 1
AOG123 is on a distinguished road

Awards Showcase
Microsoft Access 
Total Awards: 1

Default

Did you look at the attached working Ms Access Example? Look under the image thumbnail
Reply With Quote
  #9  
Old July 15th, 2008, 08:12 AM
Barn Regular

 
Join Date: Jul 2008
Location: Philadelphia, PA
Posts: 76
Thanks: 8
Thanked 0 Times in 0 Posts
Rep Power: 1
nboscaino is an unknown quantity at this point
Default

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

  DeveloperBarn Forums > Databases > Microsoft Access

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
adding numbers todd2006 JavaScript Programming 2 July 3rd, 2008 01:38 PM
Create History Table / Outcome results Rebelle Database Design Help 9 July 1st, 2008 08:33 AM
The data source 'ObjectDataSource1' does not support sorting with IEnumerable data Shem .Net Development 5 June 25th, 2008 08:07 AM
Database not updating richyrich .Net Development 5 June 3rd, 2008 10:52 AM
Help with Updating field Rebelle Microsoft Access 5 April 1st, 2008 06:45 PM


All times are GMT -4. The time now is 02:43 PM.



Content Relevant URLs by vBSEO 3.2.0