Field Entry Question

[adam.greer]

Hi

I have a large database for my company, a portion of it stores Genres of different music tracks. In this genre field there would several genres that fit into the 'feel' of a track, and we need each genre in it so our playlist queries work.

I.E Punk Pop Rock. But some because some themes are more dominent some users may enter Pop Rock Punk, this gives the same result in our playlist queries but leaves over 700 diferent types of genre feilds because of all the repeating (Punk Pop Rock and Pop Rock Punk are two distinct entries)

Is there a way to type all the genres in and the field take it's set combination of them to stop different orders of words. We currently have 25 different genres and this leaves alot of unnecessary duplicating.

This does however need to be quick and easy to type as many tracks are processed in a day.


Thanks guys

 

[Smart]

You could create a table that contains all your genres

Create a combox on your input form based on the new table

That wy the user select a genre from the combo box eliminating user typeing errors