Tables


H

Harvard

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?????
 
Ad

Advertisements

J

John W. Vinson

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.
 
H

Harvard

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.
 
Ad

Advertisements

J

John W. Vinson

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top