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

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.

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

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.

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

relationship.JPG (13.5 KB, 7 views)

Attached Files

Contacts.zip (31.9 KB, 2 views)

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.

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.

Did you look at the attached working Ms Access Example? Look under the image thumbnail

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