Updating and Adding Records via a Query

  • Thread starter Thread starter ZBC
  • Start date Start date
Z

ZBC

I am using Access 2000.
My scenario involves:
A form intended to make updates (modifications and add records) to
Table 1.
I WANTED to display data from 3 tables on the form although I am
updating only Table 1 with this form.
Table 1 has a 'many-to-one' relationship with Table 2.
Table 2 has a 'many-to-one' relationship with Table 3.

I have been unable to 'add' records to Table 1 as long as I have data
from Table 3 involved in the query!

Is there a way around this?
Will a later version of Access help?

Bob
 
I am using Access 2000.
My scenario involves:
A form intended to make updates (modifications and add records) to
Table 1.
I WANTED to display data from 3 tables on the form although I am
updating only Table 1 with this form.
Table 1 has a 'many-to-one' relationship with Table 2.
Table 2 has a 'many-to-one' relationship with Table 3.

I have been unable to 'add' records to Table 1 as long as I have data
from Table 3 involved in the query!

Is there a way around this?
Click to expand...

Sure: use Forms with Subforms (Form for the "one" side, subform for
the "many").
Will a later version of Access help?
Click to expand...

Won't make any difference, to my knowledge.
 
John,

Thanks!
The subform approach seems to work! ... never used it before ... and
I don' t think I would have ever thought of trying that approach.

Bob
 
Back
Top