Normally you wouldn't be viewing your data at the table level so the data in there is less important? It is then the relationships in forms and reports that would show you what you want to see.

Here is how my manager at work set up a database we are working on. It let's you see the names instead of the numbers in DataSheet View.

Thank you Debbie. I previously set up a database in a similar way that you have done. But using that method does cause some problems at times. I was told on the forum, that I shouldn't use that method. I am trying a different way, based on Richard's Tech help but I am obviously doing something incorrectly. Thanks for reaching out.

Colin what is the RowSource of your WorldID ComboBox? And, the Record Source for the form itself?

If your form is bound to the BirdDataT and the ComboBox is Bound to WorldID, then the only thing that will get updated in the BirdDataT is the bound column. You either need to have two separate fields:

1. One to select the World ID
2. One to enter the Bird Name

Or, you need to use some code to set the value of the Bird Name based on what is entered into the non-bound column.

Or, you need to set up a List Items edit form as shown in the List Items Edit Form video and then have some mechanism to put that in your table, if this is the format you want.

The better method, if Bird Name is bound to the World ID, is to have a "WorldT" where records have the WorldID and Bird Name, among other fields and remove the Bird Name field from your BirdT and use a query when necessary to join all the related data.

Thank you Don. Your second paragraph was correct - the form is bound to the BirdDataT and the combox is bound to WorldID.
My current WorldT is a table that imported from Excel that lists all the birds in the world. When I imported it, I gave it an Autonumber field which is the WorldID. In your last paragraph, how do I bind the Bird Name to WorldID - I am relatively inexperienced in Access. Thank you for your suggestions

Since the Name is already in the WorldT, I would just remove the Bird Name field from Bird T. There is no reason to have it in two places.

Then create a simple query that joins the BirdT to the WorldT in the Query Editor to be the form's record source if you need to see the name separate from the combo box. That way if you select a bird from the combo box, it will automatically populate the name field.

See the following image from the Query Editor. It may not be exactly like your tables, but should give you the idea.

If you're explicitly trying to move/copy information from the WorldT to your BirdT, then that's a different matter. If that's the case, let us know and we can help you with that as well or point you to videos.

Here are a couple videos for working with queries and the relationships used:

Relationships
Relational Combo
Outer Joins