AnsweredAssumed Answered

link category field to item field

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

Title

link category field to item field

Post

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

Outcomes