when trying to join tables only ID numbers show

[HParker]

I have a database with an Adjudicator Table and an InstrumentCategoryClass Table. I would like to assign an Adjudicator's Name to each record in the InstrumentCategoryClass Table but it only shows the AdjID number, not the option for the ADJFullName text.

Also if I try to add AdjudicatorFullName to the Entries Table it shows blank even though I joined them together.

[ranman256]

you join tables on like fields. then bring down other fields into the query.
we would need to see your table layouts.

[Gicu]

You probably use a lookup field in the Adjudicator table for the AdjID where you display the full name. Short answer - don't. Lookup fields in tables are a pain and they mask the real vaues being stored. Remove the lookup and use a combo box in the form where you need the fulll name to display instead of the ID.

http://access.mvps.org/access/lookupfields.htm

Cheers,
Vlad

[HParker]

I'm not sure if you can see these properly. The first two images are the top half and the bottom half of the Entries Table. I have double checked and I did not use lookup on either of the tables because I have read a lot of warnings about them.

If you cannot use these images of the tables please advise the best way to share them with you.

[Gicu]

You actually have to click on the Lookup tab on the bottom once you select the field on the top to see what if any lookup options are selected.

I have a database with an Adjudicator Table and an InstrumentCategoryClass Table. I would like to assign an Adjudicator's Name to each record in the InstrumentCategoryClass Table but it only shows the AdjID number, not the option for the ADJFullName text.

Also if I try to add AdjudicatorFullName to the Entries Table it shows blank even though I joined them together.

How are you "trying to assign"? I assume in the InstrumentCategoryClass table you have a number field (long) to hold the AdjID_FK foreign key. Then in a form you use a combo-box bound to that field with a row source like "Select AdjID,AdjFullName From Adjudicators Order By AdjFullName Ascending;". You set the column numbers to 2 and the column widths to 0;3" (and list width to 3"). Same approach would work for populating the Entries table.

For the second question - how do you join them together? Where does it show blank? In a query, in a form...

Cheers,
Vlad

[HParker]

Yes - I did click on the Lookup tab for each field. It is showing blank in a query. I will try what you have suggested and let you know. Thank you.