I would appreciate some help on three issues:

1. How do I create the Euro symbol in FM (in Word ctrl+alt+e does the job for me, but this does not work in FM even when I use the same font);

2. Is there any tree type module [freeware, shareware] available for FM to link with hierarchical data.

3. Is there a way to count none empty portal rows.

Best regards.

Can't help you with #1. Sorry but, like most Americans (and probably a whole bunch of Europeans), I don't even know what the Euro symbol looks like.

For #2 & #3, please be more specific. What is a "tree type module"? And "count none empty portal rows" makes no sense at all.

a) Well a Euro Symbol looks like this

1. For the Euro, a temporary workaround may be to copy a euro symbol from a word document and paste it into a global field in Filemaker. Then use that when you need it. Either that, or keep hitting different key combinations until you find it. I use a Mac which uses option-shift-2 for the euro. My windows machine is much too old to have such a thing on it.

2. I understand what you mean by hierarchical data, but don't understand what you mean by "data-aware tree module." If this data is in filemaker, you can create a relationship within the file between the ID field and the ParentID field; then use a portal to display child info right in filemaker.

3. To count empty portal rows, suppose the portal has 3 fields in it (Field1, Field2, Field3) and you want to know if all 3 are empty. Make a calculated field in the related file:

Empty = IsEmpty(Field1) and IsEmpty(Field2) and IsEmpty(Field3)

Then in your main file make the following calculated field:

EmptyQty = Sum(B::Empty)

where B is the name of the relationship.

Many thanks for the help!

>>2. I understand what you mean by hierarchical data, but don't understand what you mean by "data-aware tree module." If this data is in filemaker, you can create a relationship within the file between the ID field and the ParentID field; then use a portal to display child info right in filemaker.<<

Most often you can edit the trees but they are not "data-aware". You can not link them to a table that has the fields itemID and parentID. I am looking for a tree I can link to a table.

Regards.

I tried ALT-0128 (Win98). This worked in FileMaker Pro 5. I've tested it with TrueType fonts only: Verdana, Arial, Times New Roman. According to "Special Characters" it should be Ctrl-2, but this didn't work at all.

Hope this helps,

Henk

EURO:

Alt 0128 does not work with Win2000. I need this for a value list.

Best regards.

In NT 4