Entering data into form wich is composed from 2 tables

[Mishanya]

Hello!

I'd created simple form wich consolidates data from 2 simple different
tables. But when I've tried to input or change the data in the form, I
couldn't. As if it was protected from changing.
Do I have to change some definition in the form, or Access 2003 does not let
"mess" with the data in composite forms?

 

[Rick Brandt]

Hello!

I'd created simple form wich consolidates data from 2 simple different
tables. But when I've tried to input or change the data in the form, I
couldn't. As if it was protected from changing.
Do I have to change some definition in the form, or Access 2003 does
not let "mess" with the data in composite forms?

When you tell the form wizard to pull data from more than one table you are
actually binding the form to a query that joins the tables. Such queries
are often not editable. A better practice is a form with a subform each
bound to one of the tables.

 

[John W. Vinson]

Hello!

I'd created simple form wich consolidates data from 2 simple different
tables. But when I've tried to input or change the data in the form, I
couldn't. As if it was protected from changing.
Do I have to change some definition in the form, or Access 2003 does not let
"mess" with the data in composite forms?

It depends on the query; some two-table queries are updateable, some aren't
(you must have a Primary Key on the "one" side table, for starters).

However, if you have two tables in a one-to-many relationship, your best
solution is probably to use a Form for the "one" side table with a Subform for
the "many".

 

[Dirk Goldgar]

Hello!

I'd created simple form wich consolidates data from 2 simple different
tables. But when I've tried to input or change the data in the form, I
couldn't. As if it was protected from changing.
Do I have to change some definition in the form, or Access 2003 does not
let
"mess" with the data in composite forms?

I presume that means that your form is based on a query that joins two
tables. Such queries may not always be editable, though they usually are
(though some fields may not be updatable). If yours is not editable, it may
be due to some special feature of the query. Please post the SQL of the
query, and maybe we can see what's wrong.

 

[Mishanya]

Thanks 2 all of U, guys.
I've overcome the problem by simply defining a primary key in the tables.
Wich means I'm still a dummy in Access.
Anyway, thanks again for Your quick responce!

With love from Russia!
Mishanya.