Relationships question- field not showing up

[teacherdude]

Hi



I am using access for the first time, following a not-so-great tutorial from a book.

I have two tables, Table 1 and Table 2 that I have put in a relationship. They are in a one-to-many relationship.

When I open the drop-down box in Table 1 that shows the information of Table 2, not all of the information for Table 2 is showing. It has 4 fields, but only 3 are showing. The one that I have set as the primary key is not appearing.

What can I do to make all 4 fields show up?

Any help would be great. Thank you.

[boblarson]

There should be NO DROP DOWN BOX IN THE TABLE. If there is, you are using table level lookups and you really should avoid them for now (It always boggles my mind as to why people write books and include stuff that users should NOT be using as best practice).

Read here for more on why lookups at table level are "evil:"
http://www.mvps.org/access/lookupfields.htm