value list based on a calculation from one record

[jschwarz]

I have a list of people, and a salutation field that allows you to choose how an envelope should be addressed. Choices should be Mark and Anne, Mr and Mrs Smith, Mr and Mrs Mark Smith, etc.

I have this by having a field Salutation which is a value list based on a calculation field (Salutation Calc). If I display Salutation Calc, everything is perfect, but when I display Salutation, it has Mark and Anne, James and Suzanne, Mr and Mrs Smith, Mr and Mrs Johnson, etc, because it is indexing the calculation from every person's record. How can I display the field for just that one record? It doesn't have to be a popup menu, just anything that will allow someone to select one option.

I tried unindexing the salutation calc, but the value list doesn't work if the field it's looking at is not indexed. I don't think there's a way to index per record... is there?

[DanBrill]

Try setting up a self join relationship where ID=ID so that each record is related only to itself. Then create the value list to show only related records from the SJ. Each record should then have a value list that only shows its values.

Dan

[jschwarz]

Beautiful. Thanks for the help.