concrete Posted April 2, 2003 Share Posted April 2, 2003 i have a file with 3 fields id, name and category (can be A of :. now i need a value list (to use in another file) with all the names with category set to "A" pieter Link to comment Share on other sites More sharing options...
Lee Smith Posted April 2, 2003 Share Posted April 2, 2003 Lets call the two files A and B. The one with the three fields you have described will be File A for the moment. Create a calculation field in each file A & B and name it something like ~Constant and have it equal to "1" (without quotes). In File B, create a relationship to File A using the ~Constant field. In File B, Define Value List choose the second option (use a value in a Field) and use the relationship you just created. Attach the value list in the layout mode to the field of your choice. HTH Lee Link to comment Share on other sites More sharing options...
concrete Posted April 2, 2003 Author Share Posted April 2, 2003 thx lee, but i think you did misunderstand me in file A (with the 3 fields id, name, category) i have tis 1, name 1, cat a 2, name 2, cat a 3, name 3, cat b 4, name 4, cat b 5, name 5, cat a know my value list should be all the names with the category "cat a" name 1 name 2 name 5 i hope this is a bit less confusing pieter Link to comment Share on other sites More sharing options...
Lee Smith Posted April 2, 2003 Share Posted April 2, 2003 Sorry, should not try to answer question before first cup of coffee takes affect. The attachment explains it better than I can verbally. Lee Example CVL.zip Link to comment Share on other sites More sharing options...
concrete Posted April 2, 2003 Author Share Posted April 2, 2003 thx lee addition question could i create a value list with first all the "cat a" names followed by all the "cat b" names Link to comment Share on other sites More sharing options...
Lee Smith Posted April 2, 2003 Share Posted April 2, 2003 Hi Concrete, I made the field in File b a global. Change it to b and see what happens. Lee Link to comment Share on other sites More sharing options...
concrete Posted April 2, 2003 Author Share Posted April 2, 2003 hi lee that i figured out but i was wondering if i could get them bouth in one list, sorted by category I tried the sort second field thing in the value list, but then I only get 2 values (one for cat a and one for cat : Link to comment Share on other sites More sharing options...
Pupiweb Posted April 2, 2003 Share Posted April 2, 2003 That's expected behaviour You can work around that making a calc field = category & field and using that as second field in the value list It works but makes things quite kludgy ... I'd consider alternatives like a portal or making the file act as a "floating palette" .. bit of work, great effect, great flexibility Link to comment Share on other sites More sharing options...
Lee Smith Posted April 2, 2003 Share Posted April 2, 2003 Hi Giuseppe, "floating palette" - do you have a sample of this on your site? TIA Lee Link to comment Share on other sites More sharing options...
Pupiweb Posted April 3, 2003 Share Posted April 3, 2003 Hi Lee You can see an example - for completely different purposes - here: http://www.buliga.it/TipFiles/SFISearch.sit http://www.buliga.it/TipFiles/SFISearch.zip Link to comment Share on other sites More sharing options...
Lee Smith Posted April 3, 2003 Share Posted April 3, 2003 Hi Giuseppe, I downloaded those files when you first intoduced them, obviously to see how a SFI worked. Didn't connect the "floating palette" with it. Sorry, Lee Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7857 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