Linked Fields not populating

[JenelleR]

I have a database that has a table for school districts and one for schools.
I have a one-to-many relationship with the school distrcts ID. In my schools
form, when I add a new school, I use a combo box to choose the district but
the school isn't being linked to the district. I will go over to the
districts table datasheet and look at the schools and my new one isn't there.
The school district combo box is being populated from the school district
table. What am I overlooking?

 

[Mr. B]

JenelleR,

From your description, I assume that you have a table for your School
Districts and a table for the Schools in each District. The Schools table
would have a Foreign Key to the School Districts table for creating the
relationship. You state that you "go over to the districts thable datasheet
and look at the schools and my new one isn't there." If your tables are
designed properly and you would not see new schools added in the Districts
table. The new school would be in the schools table with an entry in the
Foreign Key field for the selected District.

Is your combo box where you are selecting the School District bound to the
foreign key field for the school district in the schools table?

 

[John W. Vinson]

I have a database that has a table for school districts and one for schools.
I have a one-to-many relationship with the school distrcts ID. In my schools
form, when I add a new school, I use a combo box to choose the district but
the school isn't being linked to the district. I will go over to the
districts table datasheet and look at the schools and my new one isn't there.
The school district combo box is being populated from the school district
table. What am I overlooking?

If you're using combo boxes in table datasheets... DON'T. See
http://www.mvps.org/access/lookupfields.htm for a critique of this misfeature!

Use Forms instead. On a Form, you can Requery the combo box on one form (the
schools form) from the AfterUpdate event of the districts.