Changing or Filtering Value List 
Author Message
 Changing or Filtering Value List

hey Mark,

Quote:
}I'm using Filemaker Pro 4.0 as a database for my library of musical instrument
}samples.
}
}I want the database to be designed for simple and swift use, but am running
}into a problem in relation to two fields.
}
}Field A =Instrument Categories (Strings, Horns, Woodwinds, Percussion,
}Keyboards, etc.).  Field B= All Instruments( Violin, Viola, Cello, Trumpet,
}French Horn, Clarinet, Oboe, Maracas, Rhodes, Clavinet, Piano).
}
}The Problem: I'm looking for a way to use Field A (Instrument Categories) as a
}filter for Field B, where in "Field A" I would select Strings and then go to
}"Field B" and only have "Violin, Viola, and Cello" to choose from in my value
}list.
}
}Is there any way for a field to either switch value lists based on a result
}from another field or filter out certain data based on the value from another
}field.
}
}My Field B, containing all instruments, is getting entirely to cumbersome to
}work with especially in data entry.
}
}I'm trying to keep the user interface simple, which is why I'm resisting
}having a different field for each Instrument Category.
}

Well, i can't figure a way to do what you are lookin for (i probably
don't know filemaker well enough yet) but i did figure out a way to
make your value lists change.. dynamically..  

i built a little example with repeating fields.. (just seemed easier
than defining records) and let me put the entire logic on a single
record layout..

it has lists, and a selector for the lists.. depending on which "list"
is selected, the value list to choose your selection from changes.. i
would imagine the logic could easily be extended to use field info to
create the list..

on my website there is "think different" logo down at the bottom of
the page.. click on the think different, and you will get to a little
mac-files area.. i have made a directory called filemaker-examples..
there is a copy of this little database i was using to figure out the
problem. it is called VariableSelector.sit.. it is compressed for mac..
if you are on windows, let me know, and if you want, i'll try and zip
it or some other windows thing..

hope this helps.. or at least gives you some new idea..


Sur-Tech / Ami-Tech    (408) 496-6348 Xt 247     Santa Clara CA 95050
                          www.Sur-Tech.com



Sun, 21 Jan 2001 03:00:00 GMT
 Changing or Filtering Value List

Quote:

> I'm using Filemaker Pro 4.0 as a database for my library of musical instrument
> samples.

> I want the database to be designed for simple and swift use, but am running
> into a problem in relation to two fields.

> Field A =Instrument Categories (Strings, Horns, Woodwinds, Percussion,
> Keyboards, etc.).  Field B= All Instruments( Violin, Viola, Cello, Trumpet,
> French Horn, Clarinet, Oboe, Maracas, Rhodes, Clavinet, Piano).

> The Problem: I'm looking for a way to use Field A (Instrument Categories) as a
> filter for Field B, where in "Field A" I would select Strings and then go to
> "Field B" and only have "Violin, Viola, and Cello" to choose from in my value
> list.

> Is there any way for a field to either switch value lists based on a result
> from another field or filter out certain data based on the value from another
> field.

> My Field B, containing all instruments, is getting entirely to cumbersome to
> work with especially in data entry.

> I'm trying to keep the user interface simple, which is why I'm resisting
> having a different field for each Instrument Category.

> Thank you for your help or any suggestions.
> Mark Miller

Hello Mark,

Browse to our WEB site and click our TIPS page.  The is a sample
solution called "Hierarchical Value List" which demonstrates how to
achieve what you are asking for.

Hope this helps!!!

Don Wieland
D W   D A T A   C O N C E P T S
~~~~~~~~~~~~~~~~~~~~~~~~~
HOME PAGE - http://members.home.net:80/dwieland/dwdchome.htm

Direct Line - (949) 786-9318



Sun, 21 Jan 2001 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. value lists and check boxes, automatically changing values

2. special value-list-filter (LIKE '%string%')

3. Filtering Value lists

4. filtering value-lists

5. Filtered Value List

6. Filter a portal based on a value list from a field not in the main file

7. Filters in value lists....?

8. Changes to Display values w/o changing database values

9. Filter Accross Date Range - Different Filter Value for Different Dates

10. show members with empty measure values/filters on filters

11. Dynamic Filter on TCustomADODataset where filter field data type change

12. APT : Changing Value List SQL query Dynamically


 
Powered by phpBB® Forum Software