mamawong50

Thank you! All is well, I did have one space too many in my parameter. This forum is GREAT!

Formatting the field as standard, shows both dog and cat in the field. When I change the field format to "check boxes" only Cat is selected. BTW, I am using FMP6

I have the following in my script (simplified): Set Field ["Field", ""Dog

Thanks Tom... Don't know if it makes a difference, but the relationship I created is a self-relationship. I created the calc field you suggested but am only getting a total for a single record. Basiclly, I need to have a total of all the records of a single client; then a total for the records of another client, etc.

In my database each client has several records. Each record has a calculation field named "TtlPaid". I have created a layout with a portal listing all the records for a particular client and the "TtlPaid" field for each record. I need to create a calculation field that will summarize all the "TtlPaid" fields. I have already created a summary calc field of "TtlPaid" with running total. The results I get are either a summary of a single record (if the field is placed in the Body of the layout) or a summary of all records in the database (if the field is placed in the footer.) My head is spinning! [color:"red"] Thanks to everyone who has replied to my postings for help. I have found solutions from your many suggestions.

I want to limited the number of words in a text field to 100. Can this be done?

In table view I have similar information sorted by ID#. I need a script that will identify the first record of each set of similiar ID numbers. Those identified records will become a "found" set. ID #-------- Name-----------Field3 234567--- John Smith---blah..blah

1. I created a text field named [Comments] 2. Formatted [Comments] field to be check boxes using a value list [Remarks] 3. Set up a calc field named Comm2 as text field using the following calcuation.... [color:"red"] Substitute(Comments, "

Thanks.... I used the following solution and it worked... .... use an aux calc field TexttoNum(field1)

I have a text field. Each field has a single entry with varied numbers of leading zeros..."00345", "01025. These numbers are house numbers in an address. I need to remove the leading zeros from the data. Is there a function available that would trim the zeros out?