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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
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.
 
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??
Click to expand...

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]
 
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!
 
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
 
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.
 
Back
Top