Filemaker Pro 8 Help

Status
This thread has been Locked and is not open to further replies. The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. Watch our Welcome Guide to learn how to use this site.

SemmySweet

Thread Starter
Joined
Apr 12, 2002
Messages
111
:eek:
I'm trying to combine three fields in a FM database. I wanted to first, combine first names and last names into one field, called full name. Then I wanted to have the whole list of full names combined with another field called company and that list be selectable. Hope that makes sense. Thanks!
-Jim:p
 
Joined
Oct 26, 2001
Messages
2,871
Jim: I don't use FM, but do use MS Access and write a lot of applications in it for mostly non-profit organizations. Doing what you're asking is extremely simple in Access, and I'll wager you can do the same in FM. What you want to do is concatenate (that's the official term) several fields (first and last name, and another field). If you want to do that in a report, you should put an "unbound" field in the report (one that is not bound to any field in the underlying table) and enter a formula that uses the field names and ampersands. For example, [firstname]&" "&[lastname]&" "&[other field]. The " " are spaces; if you don't want the spaces, leave the " "&s out of the formula.

If you actually want a create a concatenated field in your table/database, in Access you simply add a new field in the table definition then run a Query to update the field using the formula above.

As I say, this is a 2-minute job in Access. Don't know about FM, but I'm sure they provide something similar. Hope you can translate what I've said to FM terms.
 
Status
This thread has been Locked and is not open to further replies. The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. Watch our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top