I am new to Access Programming and am using Access 2000. Here is my problem. I am a nature photographer and am creating a database to store all of my photographs. I have a table (lets call it "Table A") with the common name and latin name of the different species I have photographed. I have a combo box on a form that selects the Common Name and stores it in a field in a different table (lets call it "Table B"). Now I want it to also store the Latin name in another field in "Table B." Does this make sense? I hope it does. Thank you for your help. If you can explain this one then I have an even more difficult question that I don't even know how to start solving. Thanks for your time.

Why do you want to store the latin name in table B. If you have the normal name in table B then you can create a query linking table A and B by the common name. You can then show all the fields from Table B and bring across the latin name from table A

HTH

Ok. I have not set up any querries yet. How exactly would this work? And how would I get it to show up on the form?

Goto queries and New. Click on design view and then select the 2 tables from the list. Close the box and then click on and drage the field that is being used in bothe tables. You can then select the fields from both tables that you want to see.

At present I guess that your form is pointing to a table. Change it to point to the query.

HTH