adding and editing records in form

  • Thread starter Thread starter jason
  • Start date Start date
J

jason

hello everyone. Havent worked in Access in a while and ran
into a pretty simple problem. here it goes.
I have a access database with 3 tables. these tables are
linked by "user name" field. i have created a form with
all fields from all 3 tables. everything works fine but i
am not able to edit or add records. does anyone know what
im missing? ive have went though all settings but am not
able to find anything. the thing i find interesting is
that if i create a second form with just fields from 1
table i am able to create new or edit records. seems like
as soon as i try to add fields from a second table is when
it will not allow me to edit or add new records from
within the form?
any help would be appreciated
thanks
 
hello everyone. Havent worked in Access in a while and ran
into a pretty simple problem. here it goes.
I have a access database with 3 tables. these tables are
linked by "user name" field. i have created a form with
all fields from all 3 tables. everything works fine but i
am not able to edit or add records. does anyone know what
im missing? ive have went though all settings but am not
able to find anything. the thing i find interesting is
that if i create a second form with just fields from 1
table i am able to create new or edit records. seems like
as soon as i try to add fields from a second table is when
it will not allow me to edit or add new records from
within the form?
any help would be appreciated
thanks
Click to expand...

A two- or three-table Query may or may not be updateable. The more
tables the less likely it will be! To be updateable you must join the
tables using a field with a unique Index (such as a Primary Key) in
the "one" side table; depending on the query you may or may not be
able to edit all the fields (perhaps only the fields in the "many"
side table).

I'd suggest if these tables are related one to many that you instead
use a Form for the "one" side table, and one or more Subforms for the
"many".
 
Back
Top