Two label questions

[Rockxyzzy]

Hi, Gang!

I'm working on an address book layout that begins with an imported tab delimited file and creates a phone directory-type layout. I'm using the label feature and I'm hung up on two problems:

-when the name is too long, I want the phone number (the phone number resides to the right of the name on the first line of the label) to become the second line of the label and not line break in mid phone number. It seems that if I can define a non-breaking hyphen (similar to a non-breaking space) and use that in the phone number, that would work. I'm not sure if this is possible on the Mac FMP, however.

-And how do I tell FMP to include the first record in the header and the second in the footer? I've created headers and footers and put a copy of <<Name>> in each one. The header one seems to work just fine when viewed in Preview mode but the footer one displays not the last entry of the page, but the FIRST entry of the NEXT page.

I appreciate any thoughts y'all might have, including a recommendation other than the Label tools to create this db.

(I've attached a sample version of my file. Don't mind the strange field names. I made them match my source text file for easy importing.)

Example.fp7.zip

[transpower]

Use a calculated field for the name so that if it's too long, ...

[Rockxyzzy]

I guess I really missing something here because my hands seem to be tied with FMP's label function. Once I create a layout using the label feature, all I get is <<fieldname>> on my layout and I can't seem to use calculations, variables, or anything remotely useful on a label.

What am I missing here?

[-Queue-]

<<fieldname>> is simply a merge field. It can be a text, number, calculation, etc. field. If you have a calcfield, you can add it to your layout using <<calcfield>>, substituting the correct name.