Lookups and Format

[raycock]

Does anyone know if there is a way to format a lookup field. I have tried without any luck. What I am doing is making a field of social security numbers that is linked to Social Security Numbers in another file. It finds all the data correctly but I can't seem to have both. Format the Social Security Number and have the field lookup the information in another file. Am I doing something wrong? And yes, the files are related and linked.

[-Queue-]

Try applying an auto-enter calculation, instead of a lookup, to the field.