Table info to form question

[Russellhoo]

I have inherited a datbased used for student information at my school. We have a Master Agreement Form the uplls some information from a table as the counselor types in info. For instance, under classes, the couselor will begin to type "Algebra" and the word algebra pops up from a linked table. If we want to change name of the "Algebra" class to "Algebra Math", I can change the name on the table and it is automatically changed to all the students on the Master Agreement form.

I have added another field and matched all the settings, as far as I can tell, and the new field works identically as we type in info, pulling it from the table (a different table), but when I change info in the table, it is available in the new field, but it will not change all students info in master agreements...I have to do each manually.

What am I missing?

 

[Scooterbug]

Sounds like you are not storing the ID number of the record from the table that stores the new field. Instead, you are storing the actual text portion.

For example, in the Algebra example, when the counselor types in Algebra, the combo box displays the word Algebra. But i'm guessing that the bound field is actually the primary key of the record that contains Algebra. That ID number is stored in the record that stores the data for the master agreements. So when you view the master agreement, it uses the ID number to find Algebra. If you change Algbera in the table, it affects any record from any table that has that stored ID.

So....you want to make sure this new field is storing the ID number. If this sounds confusing, let me know....I can over complacate things when i'm describing them.

 

[Russellhoo]

Actually, I think you may have hiot it exactly on the head! Thank you so much!