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!