Hi there, now i want to try to create a changeable title for every field, that mean the title of every field can be change every time. It is control by value of another field. I have attatch a 2 file ( main.fp5 and Reference.fp5). In the main.fp5, i have create 6 field (ID, Name, Address, t_ID, t_Name, t_Address). The first 3 field are use to store data and the other 3 use as display the title. Right now i set this 3 as global field, but actually i want to set it as calculation field and point to the value of the field in Reference.fp5 with a relationship.

The Reference.fp5 contains of 2 text field, "Title Name" and "Reference Name". "Title Name" is use to store the actual name of all the entry field display on Main.fp5. "Reference Name" use to store the text that want to display as title name, that's the value that need to use.

Thank you for helping.

Regards,

Henry

main.zip

To be clear: you're not changing the actual title of any fields; you're just changing what words appear on the screen and on printed forms as LABELS for the fields, right?

First, it seems you need something like a "category" field to indicate WHICH set of field-labels you want to appear (The main database you attached doesn't include anything like that).

Once you have the category field, it seems that calculation fields in the same database would do the job just fine... Suppose you want a certain field label to indicate "parent" for some records but to indicate "spouse" for other records. Then you can have a calc field called ContactLabel (or whatever) = [color:"blue"]Case(Category="child","parent",Category="adult","spouse")

Would you somehow need to be changing these conditions often? If so, a related file might make sense; otherwise a calc field would do it.

Please explain the actual situation (with more detail) if you are sure you need a relation...

Thak you for reply, i know that in calculation fields inthe same database can be done. But now i want is refer to another file call reference. Because if i have many databases, then i no need to create en each databases and also good for fulture changes. If i have 6 databases that need to change, i no need go to this 6 databases to change their title, i only go to the reference database and do the changes for the 6 databases. All the title for all databases are store on the reference database.

Regards,

Henry

Hello Henry

You can do what you want, but you have to set up for every field you want to have a changeable title (or better said: label) a separate constant relationship to the reference file.

Example (see attachement):

In the File Main.fp5 you need

ChangeableFieldTitleNew.zip

Ok, i got it. Thanks.

Regards,

Henry