Newbies Grumbler Posted November 9, 2007 Newbies Share Posted November 9, 2007 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 More sharing options...
comment Posted November 9, 2007 Share Posted November 9, 2007 Sounds very similar to this: http://www.fmforums.com/forum/showtopic.php?tid/180500 Link to comment Share on other sites More sharing options...
Newbies Grumbler Posted November 9, 2007 Author Newbies Share Posted November 9, 2007 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 More sharing options...
comment Posted November 9, 2007 Share Posted November 9, 2007 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 More sharing options...
Recommended Posts
This topic is 6140 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 accountSign in
Already have an account? Sign in here.
Sign In Now