Hello ,

i'm still new with FM , trying to find my way to make my own Database that help us for our maintenance job.

I made a hierarchical Value list start with Selecting "Area " , then " Equipment Category " then "Equipment" .

The problem which i have . i'm not able to select different choose in the "equipment" list , Although it show all of my equipment list , but always one equipment is selected in each Equipment Category .

For example : Area 1 ,Equipment Category 3, have 4 Equipment . . . . always  equipment 3 is selected although the 4 is shown .

Any Idea what's wrong here .??

If I'm understanding you correctly, you are describing a Conditional Value List. There are sample files at many sites, including here.

For a simple demo of CVLs, this site had lots of resources including CVLs demo.

http://www.databasepros.com/list.php?search=conditional+value+list&submit=+Find+ 

Youtube has a lot of videos that are on this subject. Here a list of videos on CVLs.

https://www.youtube.com/results?search_query=conditional+value+list+filemaker+

I like this video by Martha Zink of Soliant TV because it is a sort and to the point.

https://www.youtube.com/watch?v=2C62NlAR8vY

 

Edited December 3, 20178 yr by Lee Smith
reworded the video by Martha