combine fields into one field

[mallikai]

is there a way to combine the contents of one 3-4 fields into one field

for instance, i have a database which stores name, address, state, zip, etc. for vendors...

I have another database where I would like to just place it in one field to save space. I can just click on that one field and have all the info pop up without having layout each field separately in this d-base...

thanks

[Rumble Seat]

Yes, create a calculation field called Label.

Label = Name & "(paragraph)" & Street & "(paragraph)" &

City & ", " & State & " " & Zip & If(Country = "USA" or IsEmpty(Country), "", "(paragraph)" & upper(Country))

Then use Label as the source for a lookup in other files.

[Fitch]

I'm not sure what you mean by "save space," but you should know that this type of text calculation, while certainly convenient, actually can add considerably to the size of your file.

That said, it's usually fine if you have less than a few thousand records.

Personally, I'd display the data in the related file with merged text or fields from the vendors file. It's not that big a deal to arrange this nicely on a layout, it takes 2 minutes, and from there you can copy and paste it onto other layouts as needed.