Filemaker Po 8>>Windows XP

I am trying to find a calculation or script entry to change the name of a
field. I have found the open define database but after that I can not
figure how to select a field from the list and change the name. Is this
possible wihtout developer software??

scotlandak wrote on (10/5/2005):

No need to script.

Open File/Define Database.

You may be presented with a list of tables, in which case double-click the
table you want, which will take you to the fields list (you may already be
in the fields list). See the tabs at the top: Tables, Fields, Relationships.

Select the field, and near the bottom of you'll see an edit box for the
Field Name. Make your change, then click the Change button.

Done.

Matt

--

scotlandak <scotland (AT) nospam (DOT) ak.net> wrote:

If you need to change a field name programmatically, that's tough. If
you need to change a field LABEL showing on a layout, it's easier. Make
the field label a field itself, and change it using a SetField command
in a script or calc.

If you tell us what you're trying to accomplish by changing the field
name, perhaps there's a great new feature of FM8 that will do what you
wish.

Lynn Allen
--
Allen & Allen Semiotics www.semiotics.com
FSA Associate Filemaker Design & Consulting

"Lynn allen" <lynn (AT) NOT-semiotics (DOT) com> wrote


I want to enter new fields into my inventory layout and when I go to my
sales layout I want the text I entered in that field to be listed, and if I
change the name of the inventory item (on the Inventory layout)I want it to
reflect on the sales layout.

scotlandak <scotland (AT) nospam (DOT) ak.net> wrote:

I suspect we're not talking from the same basis of understanding here.
I've written many inventory/sales order systems, and never had to add
NEW FIELDS to both places on a routine basis.

If you want to enter new information in inventory, such as changing a
part number or adding a new part, and have that reflected on the sales
order layout, you can do that with a value list, a portal or a list view
from the inventory Table Occurance. None of this requires actual new
fields. It only requires creating new records or editing old ones.

If you've got repetitious information such as part number or description
in separate fields, then your data structure isn't built properly and
needs to be corrected.

If you are genuinely creating new fields, such as suddenly needing to
define NEW information such as region or markup, that wasn't tracked
before, then you'll have to resort to the same thing the rest of us do,
define the fields and place them on whatever layout we want them to
appear on.

Lynn Allen
--
Allen & Allen Semiotics www.semiotics.com
FSA Associate Filemaker Design & Consulting