AnsweredAssumed Answered

link category field to item field

Question asked by rgs on Apr 2, 2009
Latest reply on Apr 3, 2009 by rgs


link category field to item field


I am working on a FileMaker database to inventory a large number of musical instruments for my school district. I have a field for "Category" meaning Band, Orchestra, Elementary, ect. This field is limited to a value list. I also have a field for the specific instrument that is also limited to a value list. However, the instrument list is quite long and it would be good to be able to limit it to only instruments appropiate to each category. Is there a simple way to do this? I don't have to use the lists I don't mind building new tables if that's what it takes. After years of using MS Access, I am doing pretty good at finding my way around FileMaker but I don't do well with programing statements and sophistacted database design manipulation, so simply stated answers are appreciated. Thanks very much