multiple values for one field from all  fields in database

Hi prakash

to have all values of a Field, you can create a Value List with the values coming from that field and then make a calculation field with this calc:

ValueListItems ( Get ( FileName ) ; "Value List" )

are you referring to making a list as suggested, or are you referring to a table field containing a concatenation of all other field values for that record?

if the latter, new calculated field set to field1 & field2 & ...

i think the previous post hinted that one... but the list sounds like it may be only showing the contacts on that row.

if that isnt what you want, it may be an idea to normalise your tables further...

---

royal migthy wrote:

 

For example i have 10 fields like contact 1, contact 2..... contact 10. in a table called Contact Management. Now in the same table i create a field called show_contacts. here in this field i need all values of contact 1 to contact 10 should be display as dropdown and i want select one of the value in the list.

---

Create a calculated field with this calculation:

 

List ( contact 1 ; contact 2 ;..... ; contact 10 )

 

Then create a value list with values coming from this field.