Data entry across multiple tables

I have three tables, current contact information of PhD alumni, education
history, employment history. They are joined on an autonumber attached to
each alum. I'm trying to create a form so that I can fill in all the data at
once, their contact information, their education, and their employment, all
on one form. I can get two out of three if I use the contact as a main form
and one of the others as a sub-form, but as soon as I add a second sub-form
(manually, the wizard won't do it for me) I can no longer add any data at
all, the form is blank. Is there something I'm missing?

Thanks

I am assuing that the education history table and the employment history
table are both child tables of the contact table. If not, they should be.

It is most likely you are not setting up the forms correctly. Your main
form should have the contact table as its record source. Then you need two
subforms on the main table, one for the education table and one for the
employment table.

--
Dave Hargis, Microsoft Access MVP


"Tychocrash" wrote:

I have three tables, current contact information of PhD alumni, education
history, employment history. They are joined on an autonumber attached to
each alum. I'm trying to create a form so that I can fill in all the data at
once, their contact information, their education, and their employment, all
on one form. I can get two out of three if I use the contact as a main form
and one of the others as a sub-form, but as soon as I add a second sub-form
(manually, the wizard won't do it for me) I can no longer add any data at
all, the form is blank. Is there something I'm missing?

Thanks

My main form is the contact table and I have two sub-forms, education and
employment. I assumed they both would be automatically considered child
tables, but perhaps this is not the case. How can I check this and correct
it if they aren't?

"Klatuu" wrote:

I am assuing that the education history table and the employment history
table are both child tables of the contact table. If not, they should be.

It is most likely you are not setting up the forms correctly. Your main
form should have the contact table as its record source. Then you need two
subforms on the main table, one for the education table and one for the
employment table.

--
Dave Hargis, Microsoft Access MVP


"Tychocrash" wrote:

I have three tables, current contact information of PhD alumni, education
history, employment history. They are joined on an autonumber attached to
each alum. I'm trying to create a form so that I can fill in all the data at
once, their contact information, their education, and their employment, all
on one form. I can get two out of three if I use the contact as a main form
and one of the others as a sub-form, but as soon as I add a second sub-form
(manually, the wizard won't do it for me) I can no longer add any data at
all, the form is blank. Is there something I'm missing?

Thanks

Open the main form in design mode. Select a subform and check the Link
Master Fields and Link Child Fields properties. Those are the properties
that keep the data in a subform in sync with the data on the main form. In
the Link Master Fields property should be the name of the field or fields in
your main form's record source you use to relate to the child table. The
Link Child Fields property should contain the name of the field or fields in
the subform's record source that relate the data to the field or fields in
the main form's record source.
--
Dave Hargis, Microsoft Access MVP


"Tychocrash" wrote:

My main form is the contact table and I have two sub-forms, education and
employment. I assumed they both would be automatically considered child
tables, but perhaps this is not the case. How can I check this and correct
it if they aren't?

"Klatuu" wrote:

I am assuing that the education history table and the employment history
table are both child tables of the contact table. If not, they should be.

It is most likely you are not setting up the forms correctly. Your main
form should have the contact table as its record source. Then you need two
subforms on the main table, one for the education table and one for the
employment table.

--
Dave Hargis, Microsoft Access MVP


"Tychocrash" wrote:

I have three tables, current contact information of PhD alumni, education
history, employment history. They are joined on an autonumber attached to
each alum. I'm trying to create a form so that I can fill in all the data at
once, their contact information, their education, and their employment, all
on one form. I can get two out of three if I use the contact as a main form
and one of the others as a sub-form, but as soon as I add a second sub-form
(manually, the wizard won't do it for me) I can no longer add any data at
all, the form is blank. Is there something I'm missing?

Thanks