Entering data into form wich is composed from 2 tables

  • Thread starter Thread starter Mishanya
  • Start date Start date
M

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

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

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".
 
Mishanya said:
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?
Click to expand...


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