One to Many Forms

  • Thread starter Thread starter JW
  • Start date Start date
J

JW

I am new to MS Access. I want to make a one to many form
with 2 tables I am able to do this ok by creating forms
for both master and detail tables and then dragging and
droppng the detail form to the master form. The one
problem I have with this is that the >* navigation button
to add a new record is dimmed out and inaccessable. Is
there a way to add new child records through the simple
form?


The second thing I would like is for the master table
form to be a datasheet form, all the data in a grid. When
I create a form for the master table as a datasheet form
and drag and drop the child table's datashhet form onto
it when I run it I don't see the child table. Can this be
done?

TIA
jw jw_nyc at yahoo dot com
 
Yep that was it, it was a non updateable query.

Any ideas about the second part of my question?

Thanks
jw
 
If I understand you correctly you want 2 datasheet forms
in a single form. The only way I can see this being done
is to create a form and insert 2 datasheet forms in the
detail section. You still will need the master link field
in the form header if you want some sort of referential
integrity.

Jim
 
I am new to MS Access. I want to make a one to many form
with 2 tables I am able to do this ok by creating forms
for both master and detail tables and then dragging and
droppng the detail form to the master form. The one
problem I have with this is that the >* navigation button
to add a new record is dimmed out and inaccessable. Is
there a way to add new child records through the simple
form?
Click to expand...

On which form - the mainform or the subform? What are the Recordsource
properties of the two forms? It appears that you have based one, or
both, forms on a Query which is not updateable. The mainform should
have the main table (only) as its recordsource, and the subform the
related table.
The second thing I would like is for the master table
form to be a datasheet form, all the data in a grid. When
I create a form for the master table as a datasheet form
and drag and drop the child table's datashhet form onto
it when I run it I don't see the child table. Can this be
done?
Click to expand...

This feature is not available. I'm not sure how you would want this to
look - 1833 rows of datasheet, with each row containing one to sixty
rows of related data?
 
Back
Top