Is there a script that will allow you to change or set a field you wish to display in a table layout?

There are 4 variable fields:

sort1

sort2

sort3

sort4

One layout asks you to specify fields for the layout variable thus:

'sort1' could equal first_name if selected

'sort2 could equal last_name if selected

or

'sort1 could equal phone_number selected.

This is basically the same steps as when you are creating the layout and FMP asks you what fields you would like to include.

I would like to streamline the process a little within the database.

You can use the GetField or Evaluate functions with a field holding the desired field name.

For example,

If gSort1 is a global text field wherein you can enter or select a field name, then a calculation field of Evaluate(gSort1) will return the value of the field whose name appears in gSort1.

This works perfectly... one modification needed if possible.

Now after I set the row as either first name or last name, the field title is still sort1, or calc 1 and the fields have either first or last name information. Can I also dynamically change the field title to reflect the data in the row?

No. You can, however, use additional calculation fields to display the correct title and use them in place of the default title texts.