I have an employee table with First name, last name columns. I want to write a script to automatically concatenate the first name and last name and write it to a new column. Any ideas.

Using FMP 9.0 on windows.

thanks

A script is not used to do this. In FMP, "columns" are fields. Fields are part of the database structure and cannot be created by scripts.

Using the Manage Database command, create a calculation field and define the calculation to be:

firstname & " " & lastname

Can I then use this calculated field in a drop down list. I tried this and it works but I cannot see the drop down list.

If its a stored calc you can.

thanks for the info, found that I had defaulted the result to number when it should have been text duh! WOrks now.