I have combined several fields (Surname, First Name, Cell, email) into one field in a database. I take the associated Company Name from a different database file and incorporate it into this 'composite' field giving me (Company, Surname, First Name, Cell, email), works fine. I want to use this composite field in another database file as a drop down menu (and use lookups to fill in the fields in this file). However I cannot do this because when I try to setup the drop down menu referred to above I get the message "This Value list will not work because the field.......cannot be indexed. Proceed anyway?".
Any help would be appreciated, Thanks. Heraldo
