Composite Fields

[heraldo]

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

[mr_vodka]

You can not use it this way since you are referencing a related field. Since it is being referenced, it is unstored and can not be indexed. Furthermore, since it not indexed, it can not be used in the value list.