Go directly to Jail. Do not pass GO.

[Grumbler]

I have two FM9 DB's that are using FM9's server. DB "A" is used to store account information and has a portal which pulls data from DB "B". "B" has 110,000 records. "A" shows data in the portal for only 500 to 2500 related records from "B".

I would like to add 26 small buttons in "A" so that the user can go directly to the portal data that starts with the selected letter. This saves a lot of time as opposed to scrolling.

I would like all the related records to show in the portal and then they could click on the "M" key and go directly to the row in which the "NAME" field begins with the first letter "M".

Any help would be appreciated.

Thanks.

[comment]

Sounds very similar to this:

http://www.fmforums.com/forum/showtopic.php?tid/180500

[Grumbler]

Yes it does, however, that doesn't work or I am doing something wrong. If I understand it correctly in that example all the records are showing up in the portal. In mine, the related records are showing up and then I want to directly access the records.

Maybe I'm making it harder than it should be.

[comment]

in that example all the records are showing up in the portal. In mine, the related records are showing up

That's true, but inessential. Given a basic relationship of:

Parent::ParentID = Child::ParentID

you would then define the second relationship as:

Parent::ParentID = Child 2::ParentID

AND

Parent::gFChar > Child 2::Name