Problem with a relational combo box.  I am trying to make a "FullName" in a query witn a prefix (Mr, Mr & Mrs, Dr, etc) FNames and LName.  I have been able to do combo boxes before with no problem.  Now they are showing up with the number.  I set the field size to 0 but no dice.  I am storing the result of the combo box in  "Prefix".  I do not have PrefixID field, but I have tried that also.  Suggestions?

---

Reply from Richard Rost:

You should make a QUERY with FullName in it. Do your concatenation there. That query should output two values: CustomerID and FullName. Now use that to make your combo box.