self-join data display issue

[fmmike]

Hi,

I'm having trouble getting a display in my portal.

Here are the details:

From a custom dialog...

I prompt for a partial name (self-join relationship on indexed "Family Name")

ie "sm"

which should result with rows for: "smith" and "small"

Enter Find Mode[]

Set field ["Family Name","g_familyname"]

Perform Find [Replace Found Set]

Goto Layout ["Find Family"]

The portal appears BUT displays only the "small" row.

The "find" works correctly since it omits the non "sm%" rows.

I can click with the "index card" and see each of the 2 rows.

How do I get BOTH rows to appear in the portal?

[Vaughan]

A portal will not display a found set -- at least not without quite a lot of hacking around.

What you probably need is a "type-ahead" to dsiplay the matching names as it's being typed. A type-ahead demo can be found on the Database Pros web site

http://www.databasepros.com

I'd post a direct link but the site seems down at this instant -- do a search on the site under Resources for "type ahead" or typeahead" or something similar.

[fmmike]

That's sad to hear about not being able to use a found set in a portal...

Perhaps I am attacking this the wrong way.

I was using a custom dialog to help the user either enter a Family number (if known) or let them search by name. I was trying to help facilitate the name search by allowing them to enter a partial name and then present them a list of matches.

The type-ahead scenario doesn't bode well in the custom dialog environment.

I'm a newbie with FM, but have a background in SQL. Making the transition is difficult. I know what I want to do but struggle with the toolset...

[LaRetta]

Hi fmmike,

help facilitate the name search by allowing them to enter a partial name and then present them a list of matches.

Actually, you can achive what you wish and it's quite easy to set up. You can find a demo on Andy's website at FusionDZine under the Downloads section called Search & Go. I even included some brief instructions so it's easy to walk through.

The User types part of a name (or in the demo it's name or part of a phone number), even if in the middle of a word and the result is displayed in the portal. If the resultant find produces no match, you could have an Add Record button above the portal.

Your Custom Dialog could simply replace the gSearch field that I use. The results are displayed in a portal and then the User clicks the row to jump directly to that record within the same file. It is based upon a self-join but can just as easily be used for regular relationships.

But the reason only one row may be displaying could simply be because you have the field too high and too far to the left in the portal. Try moving all rows down and make sure none are near the left portal edge. I doubt that's it in your case but you might check your portal ... that one (one-row display problems) catches many people off guard.

LaRetta

[fmmike]

Thanks LaRetta.

I downloaded the file and gave it a quick read. My eyes are starting to blur

but that appears to be what I'm looking for. I'll play with it tommorrow.

- and be back with questions/praise/commentary.

Have a good West Coast PM (I'm in SF CA area)

[fmmike]

I'm still having display issues - even after great review of your example.

Something still doesn't click. I have attached a sample file. There are many 'pauses' to display the progression. I'm getting some kind of cartisian join, but can't understand where my FMP code is confused.

TIA

test_of_portal.ZIP

[dbruggmann]

I just inspected your file and found, that you catched the wrong

[fmmike]

THANKS!

I got so involved in all of the data movement/processing that I didn't catch that. It works like a charm now.

... And I learned afew things along the way!