AJB_UMASS Posted January 19, 2005 Share Posted January 19, 2005 I don't know if it's possible to accomplish the following or not: Say you have a data table - each record in the table has three fields: Brand (Apple, Dell, DEC, Samsung, etc.) Type (Computer, Monitor, Mouse, Keyboard, etc.) Color (Beige, Black, Grey, etc.) You want to view these records via a portal - but you wish to be able to filter the portal contents on the fly. You define 3 global fields: g.Brand, g.Type, and g.Color. You set up the global fields with value lists, each matching possible entries in your data records. Now - if you enter 'Apple' in the g.Brand field, the portal should show only those records that are Apple brand. If you then _also_ enter 'Monitor' in the g.Type field, the portal then only shows those records that are Apple-brand monitors. And so on, with the g.Color field. Is this even doable? Any help would be appreciated! Andy Link to comment Share on other sites More sharing options...
Søren Dyhr Posted January 19, 2005 Share Posted January 19, 2005 Yes make a stacked relation from calc's looking like this Case ( IsEmpty ( g.Brand );ValueListItems ( Get ( FileName ) ; "Brands" );g.Brand) ...to corresponding fields in the related table. This is done to prevent empty values in the globals preventing something to show up in the portal. If none of the globals have values is the entire database related shown. --sd Link to comment Share on other sites More sharing options...
mattlight Posted January 20, 2005 Share Posted January 20, 2005 I like the sound of this but S Link to comment Share on other sites More sharing options...
Søren Dyhr Posted January 20, 2005 Share Posted January 20, 2005 The calculation you have done is a way of combining three fields worth of data somehow. The calc is used in the global and also in the related table's record per each item. Then there is a relationship setup case = case. Not quite I'm afraid, the calc makes sure to include all values that could occure in the coloumn ...the idea is not that far from the type ahead you mention - if it's based on multiline keys. But these days are they not nessersarily the only solution to the typeahead feature. It might be better if I made you a template please await!!! --sd Link to comment Share on other sites More sharing options...
Søren Dyhr Posted January 20, 2005 Share Posted January 20, 2005 There you go! --sd Popglobal.zip Link to comment Share on other sites More sharing options...
AJB_UMASS Posted January 20, 2005 Author Share Posted January 20, 2005 Sorry! I got so wrapped up in trying your suggestion, that I forgot to thank you in the first place. Your suggestion worked fine - thanks so much. AJB Link to comment Share on other sites More sharing options...
mattlight Posted January 20, 2005 Share Posted January 20, 2005 thank you I will check it out. Link to comment Share on other sites More sharing options...
mattlight Posted January 26, 2005 Share Posted January 26, 2005 S Link to comment Share on other sites More sharing options...
NFD Posted January 28, 2005 Share Posted January 28, 2005 I've been doing this another way (see attached), but was really pleased with your example as it requires less storage. My solution requires a value in all global fields, and uses dynamic value lists for the global fields, to show shortened lists with each selection. Thanks much! allglobal.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7021 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