Hi There,
Very new to access. I have a simple database with several tables and a central table with relationships referencing the others. I would like to work out how to have a field automatically have its contents entered determined by the previous field.


I have a Names Table with a field for common names and a field for the corresponding latin name
I have the central table - Movements that has Common and Latin fields taking their contents from the name table via combo boxes.
When someone adds a common name into the field how do I get the Latin name field to automatically fill itself in with the matching latin name?

Many thanks in adavance for your help
Graham