Hi there,
I am a newbie and have written a database (access 2007) for plant management. I would most appreciate help to what I think is a very basic problem! I am really stuck on autfilling a field.
Topline: When I pick the Plant Scientific Name on my form, I want it to auto populate the Common Name.
Plant names are in TABLE one...(this also has a primary key)
Plant Scientific Name
Plant Common Name
TABLE two also has a bunch of other data, (this table includes two fields for the plants above as a lookup to that other table)
Date recorded
Place found
Co-ordinates.
I have created a form with all fields. Including the Plant ones as a lookup.
What do I need to do so when I pick my Plant Scientific Name - it auto fills my Plant Common Name?
Thanks so much in advance.