Jump to content

Go directly to Jail. Do not pass GO.


Grumbler

This topic is 6071 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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.

Link to comment
Share on other sites

  • Newbies

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6071 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.