Hi all,

I'm very new to this so please bear with me...

I am trying to create a datbase for a casting agency, and I've been trying to crash learn my way through FMP7 for the last three days or so, and whilst I am going fine, I have one major question

Can anyone tell me (and I'm sure this should be an easy one), how can you create a searchable field that searches across many different fields that carry the same value. Part of the database includes the clients skill (Musical Instruments) for example. There is a pop-up menu which has a list of instuments on it (piano, guitar, flute etc etc). Then i have another field under that with the same pop up menu, and then another one under that again and so forth (Music1, Music2, Music3, Music4 etc). The person may be able to play 5 seperate instruments. Each of these menues are a different field with the same set of values (so that when you pick a value in one it doesnt change the others to the same)

The problem here is that if you want to search for someone that can play piano, how can you create a single field that will search all the related fields, because if you want to search for Piano using the standard find command, it has to be entered in exactly the same field and not in another one that has the same values (Does this make sense).

Ideally i want to have a search page with just one of each of the skill flyout menues, which will search all the related skill fields in the original database.

Please help me - i am so out of my depth

Nicholas

Now here is a classic case for a repeating field.