Can I Edit or Add the form which the data source is from two linke

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

Guest

Hi:

I have a form, the data is from two linked table (using primary key and
foreign key), it is very good for me the navigate those record, but I find I
can't edit or add new data through this form.

Is that always the case, or may be I need do some settings for this form?

Thank you very much.

James
 
Hi:

I have a form, the data is from two linked table (using primary key and
foreign key), it is very good for me the navigate those record, but I find I
can't edit or add new data through this form.

Is that always the case, or may be I need do some settings for this form?

Thank you very much.

James
Click to expand...

If you have a one to many relationship, consider using a Form for the
"one" table with a Subform for the "many". This is actually simpler
for editing, since it doesn't show duplicate values for those "one"
table records which have multiple matches.

There is a Help topic that you can find using the term "updateable".
Not all queries are updateable, though a simple two-table join with a
Primary Key defined should be.

John W. Vinson[MVP]
 
Back
Top