Tables

I have 2 tables: Table1 & Table2. There is a one to many relationship
between Table1 and Table2. I have a form based on Table2. I built the form
after there was already data in tables1 & 2. The form successfully enters
data into Table2. I have a subdatasheet that links all records in table2 to
the records in table1. i can see all data that was originally in table 2,
but nothing that has been entered in table2 from that form. Does anyone know
why?????

On Fri, 29 Feb 2008 10:46:01 -0800, Harvard
wrote:

I have 2 tables: Table1 & Table2. There is a one to many relationship
between Table1 and Table2. I have a form based on Table2. I built the form
after there was already data in tables1 & 2. The form successfully enters
data into Table2. I have a subdatasheet that links all records in table2 to
the records in table1. i can see all data that was originally in table 2,
but nothing that has been entered in table2 from that form. Does anyone know
why?????

I'm confused. You say "The form successfully enters data into Table2" and
"nothing has been entered in Table2".

What's the Recordsource property of the form? How are you ascertaining that
nothing has been entered? If you have a one to many relationship, do you have
some provision for entering the foreign key link to Table1? Ordinarily one
would use a Form based on Table1 with a Subform based on Table2, using the
appropriate fields in the master/child linking field properties.
--
John W. Vinson [MVP]

actually, that's exactly what i did. so, the record source for the form is
actually Table1. And the form, does have the subform for Table 2. The
problem is when I enter data in the subform Table 2. The form shows that the
data has been successfully entered. So then I go to the actual table: Table
2 and verify that the data is there. It is. However, when I go to table
one, and access the subdatasheet (Table 2) the records are not there.

"John W. Vinson" wrote:

On Fri, 29 Feb 2008 10:46:01 -0800, Harvard
wrote:

I have 2 tables: Table1 & Table2. There is a one to many relationship
between Table1 and Table2. I have a form based on Table2. I built the form
after there was already data in tables1 & 2. The form successfully enters
data into Table2. I have a subdatasheet that links all records in table2 to
the records in table1. i can see all data that was originally in table 2,
but nothing that has been entered in table2 from that form. Does anyone know
why?????

I'm confused. You say "The form successfully enters data into Table2" and
"nothing has been entered in Table2".

What's the Recordsource property of the form? How are you ascertaining that
nothing has been entered? If you have a one to many relationship, do you have
some provision for entering the foreign key link to Table1? Ordinarily one
would use a Form based on Table1 with a Subform based on Table2, using the
appropriate fields in the master/child linking field properties.
--
John W. Vinson [MVP]

On Fri, 29 Feb 2008 13:30:00 -0800, Harvard
wrote:

actually, that's exactly what i did. so, the record source for the form is
actually Table1. And the form, does have the subform for Table 2. The
problem is when I enter data in the subform Table 2. The form shows that the
data has been successfully entered. So then I go to the actual table: Table
2 and verify that the data is there. It is. However, when I go to table
one, and access the subdatasheet (Table 2) the records are not there.

Well, then there's something wrong with the linking to the subdatasheet. On
what field are the tables related? Is the foreign key to Table1 in fact filled
in correctly? What are the properties of the subdatasheet? I never use
subdatasheets so I'm not sure what might be wrong...
--
John W. Vinson [MVP]