Hi:
I saw someone demonstrate this trick today and I would like to know how to do it: he opened an Access 2000 table, clicked on a column field, and a drop-down list appeared of different values. He clicked on one, and then opened another table to show me what had taken place. In that second table, another field had been updated, its value changed to what he had selected in the first table.

He couldn't tell me how to do this, he said, because someone else had done it in the database before him.

I would love to know how this is done, if anyone can give me a hint.

Thanks in advance!

Either through code, or established a relationship with Cascade Update Fields

He did it through Cascade Update Related Fields. Open the relationships window and double-click the join line between the two tables of interest.

BTW, he also used Lookup Wizard, which we frown on greatly around here, to create the dropdown list in the table field.