Combo Box Lookup

[LaughingBull]

I have 2 tables and one form. Table one is for agencies and all their info. Table two is for donations and the agency cell is a lookup from the agency table. On the form I put a combo box for a lookup of the agency name to bring up the record for that agency. What i am experiencing is when I click the down arrow on the lookup box all the is there is a number and not a name. How can I fix this?

[ItsMe]

The number you see is likely representative of the ordinal position of the element within your Lookup field. Because I do not choose to use Lookup Fields at the table level, I can't be a lot of help. I will say that there are ways you can address the issue via a Query Object. Keep in mind there is more than one way to support a Lookup field in a table. For instance, the source can be a value list or it can be another table.

The easiest would be to get rid of that property in your table. Having said that, there may be one or two reasons you would want to keep it.

[orange]

Sounds like you have this set up

Agency--->AgencyDonation where an Agency can make 0,1 or Many Donation(s)

I would NOT use a lookup field in a Table. The Lookup field in a table is a concoction invented by M$oft to "help new users of MSAccess". It is specific to and limited to MSAccess and (along with multivalued fields) is not a good practice generally. Use a separate Lookup table -a tried and true approach that can be used in any relational database.
See this for more info.