Please help = could mean the difference of having a job or not!!!
Thanks and God Bless You!!!
Okay, perhaps I did not ask the right way and it is confusing.
The file you can download is the CONTACT MANAGEMENT databse, only it has the GENRE section taken from the MUSIC LIBRARY collection and the contacts are all Music contacts and I want to set it up so I can check off what type of music they like, then down the road, add additional items for film/tv executives, like what they are looking for in Music, or what type of movie they are doing.
If know one knows how to do, what type of table is it that I need where I can have an unlimited amount of check boxes and then be able to sort buy them depending on what is there.
Presently, I get the error, ""I am getting an error when I select the table, "This operation could not be completed becuase the target is not part of a related table,"
The error message is telling you exactly what is wrong. You've add a new table to your database but you haven't linked it to the Layout's table occurrence in Manage | Database | Relationships. Since you haven't defined a relationship, FileMaker has no way to tell which record in Music Library to Link to the current record in Contact Management.
Add a contact ID field to Music library and then link Contact Mangement::Contact ID to Music Library::Contact ID and you'll no longer get this error message. If the Genre field is the only field from this table that you will be using, you could also simply define a text field in Contact Mangement and format it with the check box value list. If you will have multiple Music Library records to link to the same Contact Mangement record, you should place this field from Music Library in a portal.