Cant enter information into table with query

[Tom via AccessMonster.com]

Hi, I know that my biggest problem is in understanding what I am doing but Im
hoping I can get some help here. Ive added two tables to a query window. The
tables are related one to many. When I run the query it allows me to enter
info into the first table ( the one side), but it wont let me enter info into
the other table fields for the many table. I think that it wants info in the
one side table first since the many side table is dependent on that info
being present. When I try to enter info into the many side table it just
beeps and wont let me enter any data. How do I enter data into both tables
and have the records match up with each other?

Thanks

 

[Guest]

In the relationship set the Cascade Updates.

 

[Tom via AccessMonster.com]

In the relationship set the Cascade Updates.

Hi, I know that my biggest problem is in understanding what I am doing but Im
hoping I can get some help here. Ive added two tables to a query window. The

[quoted text clipped - 7 lines]

Thanks

It is set, and it still does not work. I know this is something simple, I
just dont know what.

 

[Rick Brandt]

In the relationship set the Cascade Updates.

Hi, I know that my biggest problem is in understanding what I am doing but
Im
hoping I can get some help here. Ive added two tables to a query window. The

[quoted text clipped - 7 lines]

Thanks

It is set, and it still does not work. I know this is something simple, I
just dont know what.

The query must include the Primary Key of the table being edited. Generally you
are better off not trying to edit multi-table queries. Even when Access allows
editing you can have unexpected results.

 

[Tom via AccessMonster.com]

[quoted text clipped - 7 lines]

It is set, and it still does not work. I know this is something simple, I
just dont know what.

The query must include the Primary Key of the table being edited. Generally you
are better off not trying to edit multi-table queries. Even when Access allows
editing you can have unexpected results.

Then how do I get my data into related tables at the same time. Example: I
made an address table to hold business address info and linked it to a
business table to store info like business name. They are in separate tables
because the business can move and another business can move in with the same
address. All Im trying to do is enter information about a business and have
that info go into both tables.

Thanks for responding.

Tom

 

[Tom via AccessMonster.com]

[quoted text clipped - 5 lines]

are better off not trying to edit multi-table queries. Even when Access allows
editing you can have unexpected results.

Then how do I get my data into related tables at the same time. Example: I
made an address table to hold business address info and linked it to a
business table to store info like business name. They are in separate tables
because the business can move and another business can move in with the same
address. All Im trying to do is enter information about a business and have
that info go into both tables.

Thanks for responding.

Tom

Isn't this the whole point of having table relationships, being able to pull
info out of several tables at once and updating several tables at once?

 

[Rick Brandt]

In the relationship set the Cascade Updates.

[quoted text clipped - 5 lines]

are better off not trying to edit multi-table queries. Even when Access
allows
editing you can have unexpected results.

Then how do I get my data into related tables at the same time. Example: I
made an address table to hold business address info and linked it to a
business table to store info like business name. They are in separate tables
because the business can move and another business can move in with the same
address. All Im trying to do is enter information about a business and have
that info go into both tables.

Use a form with a subform.

Isn't this the whole point of having table relationships, being able to pull
info out of several tables at once and updating several tables at once?

Not at all. The point is maintaining data integrity. Access is actually one of
the most forgiving database engines when it comes to editing a multi-table
query. In many system that is never allowed regardless of how the query is
configured or which table you want the edits applied to.