multiple values for one field from all fields in database
hi
this is prakash. I need all fields values has to come in one field. is it possible. if so please guide how t do it.
a field should take all field values in database.
please help me in this regard
thanks
prakash
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 & ...
hi friends
my requirement is like this. 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.
Is it possible . Please help me. My client requirement is like this. I thinking it is not possible.
please help me whether it is possible or not
Thanks
Prakash
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.
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" )