Conditional value lists do require a relationship, but that relationship can
be with the same file (a self join).
In your example, the records need a field to choose between Hardware or
Software. Assume this is a text field, "Type", formatted with a value list
(Hardware, Software).
Now create a relationship, "Self_Type", using that field as the match field
on both sides.
Let's say the second value list if for the field "Product_Name". In the
Value List definition dialogue box, use "Use values from field:", and then,
"Only related values", choosing the relationship "Self_Type". Only the
values from those records with the same Type will display in the value list.
--
John Weinshel
Datagrace
Associate Member, Filemaker Solutions Alliance
Vashon Island, WA
(206) 463-1634
Quote:> Hi everyone,
> I am trying to get a conditional pulldown menu to work in my program. I
am
> stuck and don't know what else I have to do.
> First pulldown menu: 1. Hardware 2. Software
> When select "Hardware", I want the second pull down to give me the
hardware
> valuelist. When I select "Software", I want the same second pull down to
> give me my software valuelist. I can't get this to work right. And help
> will be appreciated. Not even sure if I have to set relation and value
list
> on a different file. The hardware and software valuelist is on the same
> file.
> Does anyone know if their are good sources for Filemaker Pro 5 help
Online?
> Thanks.
by