Portal is the right tool?

[Tom007]

Hi

I need to develop a simple dictionary (NOT a Filemaker Dictionary) that have the word and the explanation of that word. That's it. All in Browse mode. The idea is to click on the list of words and appears automatically the explanation.

This database have three fields: Word, ID, Explanation.

The problem is that need to list 20 records (of thousands) of the Field Word with portal (or other way) with scroll bars and when do a click on any word then must appears the explanation in other field as I mention above. I try to create a relationship of the ID itself to get the chance to use portals but don't works... (It works in other FM databases made it by me)

The only way I see to list the 20 word records is to reduce the layout's body near the height of the field and then can list it, but can't have place to explanation's field. Portal seems to be a solution but can't find a way to use it.

How can do this design in Filemaker?

Thanks.

Tom

[Vaughan]

If you have FMP 10 and later, create a summary report and display it in browse mode.

[Tom007]

Thank you, but don't works.

[Tom007]

Placing a field in a layout body part and matching the height of field with the body then you got the result that I want: listing all the records (with list view effect)... Can I do this with portals? I create the portal and the relationship and only list ONE record and NOT the list of record that was setting.

If I have 500 records want to list it on a Portal with scroll bars but Filemaker Pro 11 Advanced v2 for Mac don't do it.

Can you help me?

Thanks.

[Tom007]

Ok, I got the solution re-writing the relationships.

Have all the records listed in a Portal.

The goal is to click one record of the portal and need to appears the description in the field that is a very large field.

I try lookup but is not a solution and when click in another record in the portal, stay in the first.

Any idea?

Thanks.

Edited October 8, 2010 by Guest

[bruceR]

Pretty hard to have any ideas until we see a copy of your file. Please post a copy, or a simplified example.

[Tom007]

Thank you, Bruce, for your advice... I'm newbie in this Forum

Here is the file DICTIO.fp7 and zipped DICTIO.zip in attachment.

Please keep in mind that want all working in Browse mode only.

I create field CODIGO with the same value to create a portal to list all the files to use in form view using TOPIC field.

Need 3 things:

1) When click any item of TOPIC field then must be appears the value of DEFINITION field automatically. Like lookup effect but without exit enter mode. Only with a click in the word of TOPIC must trigger a find for DEFINITION. Now appears the first text value only.

2) Can't make work Quick Find under TOPIC Field to show DEFINITION content. How can do it without loosing this design?

3) I see a lot of applications that have "sensitive keystroke"'s effect. I mean, when you type the first letters in TOPIC Field then appears the value simultaneous as you type each letters. Can add this effect with Filemaker?

Note that this database have an ID field to use it as parent in relationship if you need it.

Can you help me?

Thank you :-)

Tom

DICTIO.zip

[Tom007]

Note: In Layout PORTAL you can know the real value of Definition field. Do a find and change the ID and you'll see it.

In RAEBASE Layout, it's wrong, only shows the first value of definition.

[comment]

How about:

DICTIO11.zip

[Tom007]

THANK YOU VERY MUCH!

It's perfect!

The only problem is quick find and find mode don't works. Can't find nothing.

How can fix this last problem?

Thanks you again -)

Tom

[comment]

Well, relationships are one thing and found sets another. A portal is based on a relationship and it will ALWAYS show all related records (subject to filtering), regardless of any found set.

[bruceR]

Maybe like this?

DICTIO11.fp7.zip

[Tom007]

Yes, that's the idea. Thank you, Bruce.

Please let me make one more question -)

There is a way to make a click on one word in Definition field and then jump directly to the meaning in Topic field?

That's the dictionary's way algorithm.

I explain this:

1) Do a quick search with word "abajo" on Definition field.

You got in Definition field:

abajeño, ña

(De abajo).

1. adj. Natural de El Bajío. U. t. c. s.

2. adj. Perteneciente o relativo a esta región de los Estados de Guanajuato, Michoacán y Jalisco, en México.

3. adj. Am. Natural o procedente de costas y tierras bajas. U. t. c. s.

4. adj. rur. Arg. sureño.

2) Want to make a click in the word "abajo" in the first line of Definition field ("De abajo") and Filemaker must JUMP directly in Topic to find the meaning of "abajo" and exit the word abajeño, ña

3) The idea is to make a click in ANY word of Definition and find automatically the meaning in Topic (and list it) "jumping" to the word in Topic.

It's like a simulation of the hyperlink.

Thank you.

Tom

[bruceR]

Sorta like this.

DICTIO11.fp7.zip

[Tom007]

WOW!!!, BRUCE, YOU'RE AND EXCELLENT PRO!!!

Very powerful Forum that makes Filemaker so attractive.

THANK YOU -)

Bruce, don't want to abuse, but let me put the final "strawberry" to the "cake".

I saw database projects using Objective C (it's nightmare to do it with XCode :-) and another high/medium/low level languages and there's a nice algorithm in search mode and want to know if can be done with Filemaker in this little file inside the portal on topic field in this case.

Explanation: The effect I saw works searching the records simultaneous in any keystroke without using return to trigger the process.

For instances, in quick find search box on Topic Field:

1) If I press (without return) "a" find all words begins with "a".

2) Now "a" is in the quick find search box and press "b" (you read "ab" in the search box) and appears al words beginning with "ab".

3) press "a" again ("aba" in search box) and appears all words beginning with "aba".

4) Finally you enter the last letter "c" ("abac" in the search box) and you get 11 words beginning with "abac".

Conclusion: The attractive secret of this algorithm in that you don't need to press return. It's works directly in any keystroke. Each keystroke perform a find WITHOUT using return that must be done with Quick Find.

If my memory don't fails I saw this effects using Value Lists in Filemaker or others pop-menu, but don't remember and I'm not sure.

Obviously, this process is more fast than using key return to trigger the search task.

Thank you again :-)

[Tom007]

Hi Bruce

Don't worry, I found a way to create the algorithm using Portal Filtering with Script Triggers refreshing the portal automatically. It' works -)

Regards,

Tom