Duplicate Value in Value List

[Anh_Tran]

I would like to know how the duplicate can show on value list. For example I have a database A with frield Num( number)

Num

1

2

3

1

Base on the data above , I make the value list but the popup can only show

1

2

3

I want to see

1

2

3

1

...IS there any way to see all value including duplicate in value list?

Thanks for your help. I really appreciate .

[LiveOak]

Value list are based upon indexing. FM only generate an index once for each unique value. You can make a "value" show up twice by setting the indexing to "ASCII" and using a non-printing space (option-space), but the value list order will be a sorted order, not your entry order. The "value" won't actually be the same as one will be a "1" and the other an "1option-space".

The purpose of a value list is really to allow the selection of unique values. Why do you need a value to be repeated?

-bd

[Anh_Tran]

Dear BD

It does not work for my case .. I don't understand what you mean (option-space) how do I find this option?

Oh I want to see duplicate value because I want to see a list of client company ( same company) but different contact names. So when I created a value list based on company name then I can see only one company...let's say Standard life ...I want to see many standard life with different contact name so that I can chose to select them

Thanks for your help

[CobaltSky]

In that case, simply having duplicate values in the value list won't help you becuase the user won't know which contact for 'Standard Life' (as in your example) they are selecting.

If your value list is based on a field, I suggest that you create a new calculating field with the formula set to:

CompanyName & " - " & ContactName

---

Then base your value list on this new calculating field. It will then display the company names followed by the contact name - so users will know what they are selecting.