Simple ACCESS Help Needed. Any Help Is Much Appreciated.

[RBARR1618]

Hello, I am very new to access and am setting up a user friendly database.



I will try to outline the situation the best I can.


I have 2 tables: (Both tables have the same exact field names, and table #2 has 1 extra field which doesn't need to be changed)
The fields are:
-Breed
-Species
-Hair


I want to make a user friendly form with 3 fields. The user inputs the main field, presses a button and it automatically populates the other 2 fields with the matching data. (Example: The user enters "Black Labrador" in the first field, presses a button and it pulls the data from table #1 and populates the other 2 fields with "Dog" & "Long Haired")

Then, I want another button that will take the information from those three fields and update the information on table #2 to match it. (Table #2 has one extra field which is always constant, and that is why I need the info pulled from table #1 into table #2)

It seems like it will be very simple, but I just cant figure it out. I tried relating the tables with no success.

Any help is very much appreciated. Thanks in advance!

[RBARR1618]

Maybe these pictures will help. The form is how I want it to work, as of now it is just for show. How can I make it a reality?

[RuralGuy]

It sounds more like a school project that a real world problem. We're not in to school projects on this forum.

[RBARR1618]

Umm thanks for the help big guy....

Maybe you don't want to help me, but if somebody with a good consciousness on this forum would like to help me I would appreciate it.

[RuralGuy]

I actually enjoy helping, which is why I'm on this forum, but it does not help the poster if we do the homework. If you can ask why a specific operation does not do what you want then suggestions can be offered. Outlining a complete process and saying you can't figure it out is way too broad a post.