I can't get my Tables updated automatically by using an input Form

M

Mercadogs

I continue getting Error Message 3164 "Field cannot be updated"

I changed all the Field size of the all the foriegn keys on the Main Table
from
"double" to "long integer" which allowed me to changed the referential
integrity and checked both boxes.

However the problem still persists. If I add a new record on a table the
main table
does not update automatically with new info.

Can somebody help me??
 
D

Douglas J. Steele

If I'm understanding you, you're trying to update a child table, and expect
the parent table to automagically get updated as well.

That's not how relationships work: you must insert the data into the parent
table, and then insert the data into the child table as two separate steps.
 
J

John W. Vinson

However the problem still persists. If I add a new record on a table the
main table
does not update automatically with new info.

Can somebody help me??

Not without some more information, no.

I presume you're using a Form?

What is the Recordsource of the form?

Are you updating one table and expecting some *other* table to automagically
update too? If so, it won't.

John W. Vinson [MVP]
 
M

Mercadogs

Thanks for the quick reply!

So you're saying that updating my data might not be as simple as I think?
Are all these steps necessary regardless of the type of relationship (mine
is a one-to-many)?

Could I do some type of query that would update the tables simultaneously?
I just thought there had to be a more simple way.

Thanks again!
 
M

Mercadogs

Thank you John for your reply!

Yes, I am using a form that I created with the wizard (it is in Form,
sub-form style) to try to update and add records.

Before using Access, I had my info on a table. There was a lot of
repetitious text, so I made additional tables (two columns each) with primary
keys to represent the repetitious text. These primary keys show up as foreign
keys in what I call "a main table". All the relationships are one-to-many.

So the form represents the data in1 text form of the information. I was
intending that if I typed any new information into the form, then the tables
would record the text and automatically assign a primary key in the adequate
tables.

Are you saying this can't be done?

Thank you all for your help!

--Gabriel Mercado
 
D

Douglas J. Steele

Well, you shouldn't be working directly with the tables: you should always
use a form.

With a form, you can set things up to have the value put in both tables.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top