I have two tables. Table One: Dancers, 6 fields. I want to fill categoryid field as I create the new record based on contents of field skill and state if they are present in another table called Categories.
Table One: Dancers
ID firstname lastname skill state categoryid
1 John Edward Ballet California
2 Ed Thomson Tap London
3 Natasha Curtis Ballet Australia
4 Shen Willson Modern Kansas
Table Two: Categories
categoryid categoryname
1 Dancers/Ballet/United States/Alaska
2 Dancers/Ballet/United States/California
3 Dancers/Ballet/UnitedKingdon/Wales
4 Dancers/Ballet/UnitedKingdon/London
5 Dancers/Tap/United States/Alaska
6 Dancers/Tap/United States/California
7 Dancers/Tap/UnitedKingdon/Wales
8 Dancers/Tap/UnitedJingdon/London
9 Dancers/Ballet/Australia
10 Dancers/Modern/United States/KansasAttachment 7937