Automatically populate field with multiple lines

[Janie]

I'd like to populate a field with multiple lines of text. For example, if
the user chooses the name John Doe from a drop-down list, I would like John
Doe's "info" field to populate with his contact information, formatted like
this:

123 Main Street, Suite 100
Elmwood, Texas 12345
Phone: 123-456-7890
Fax: 987-654-3210

Is there any way to do that? Thanks.

 

[Ben Walters]

Hey Janie,
You should be able to do this using a "concat " function on the field your
wanting the data to appear in. You would also need to use some filters on the
values you specify in the concat statement.
If you need more info let me know and I'll shoot a post up for you

Cheers
Ben Walters

 

[Ben Walters]

Hey Janie,
You should be able to do this using a "concat " function on the field your
wanting the data to appear in. You would also need to use some filters on the
values you specify in the concat statement.
If you need more info let me know and I'll shoot a post up for you

Cheers
Ben Walters

 

[dixieee]

yes Janie u should be able to do this by using the concat "formula". u will
add something like invisible fields that will not show on the form (either by
deleting them after specifying everything or by creating them from the right
pane) and then add the control in which u want all the info to appear, go to
its properties, and concat all the fields u want. in between the fields, add
" " to have spaces between words and/or numbers

check this post if u need more info about populating fields from secondary
data:
http://msdn.microsoft.com/newsgroup...r=US&mid=8f789d22-62ea-4c8b-baa0-c8a81ba519e4

(thanx to Adam for that )
hope it helps..
Dixieee

 

[Janie]

Thanks for the info. A couple more questions. How do I get the information
to appear on separate lines instead of simply having spaces between the words?
And this may complicate things.... Here's the deal... I have a list of
contacts in a Sharepoint custom list. If someone chooses "John Doe" I want
his address to automatically appear in the address field. Should I store his
address in the same custom list --- or where? Thanks!

 

[Janie]

Thanks for the info. A couple more questions. How do I get the information
to appear on separate lines instead of simply having spaces between the words?
And this may complicate things.... Here's the deal... I have a list of
contacts in a Sharepoint custom list. If someone chooses "John Doe" I want
his address to automatically appear in the address field. Should I store his
address in the same custom list --- or where? Thanks!

 

[Janie]

Could I use Master/Detail to do this? I have tried, but I'm confused as to
how to bind the Master to a field. What kind of field do I create that can
hold an address?