My ultimate goal is to reach a point where I can do an append query based on the results of the query.
Tables invovled
FileNameTbl: IDFileName, FileName
1 BackgroundTextureRoughBlack
2 YellowSmoothTextureAbstract
FileNameSnipetsTbl: IDSnipet, Snipet
1 Black
2 Rough
3 Smooth
4 Yellow
5 Texture
ColorNamesTbl: IDColor, Color
1 Yellow
2 Black
TextureTbl: IDTexture, Texture
1 Rough
2 Smooth
Query needed: Somehow pull out the words Yellow or Black from the file name (FileNameTbl) and get the IDColor that will be appended to original FileNameTbl.
Then I would like to do the same thing (hopefully simultaneously) for the texture.
I'm stuck. I've done a query with the inst function, bascially running a new update query for each field in my color table, but that was tedious.
Any help is appreciated.
Tables invovled
FileNameTbl: IDFileName, FileName
1 BackgroundTextureRoughBlack
2 YellowSmoothTextureAbstract
FileNameSnipetsTbl: IDSnipet, Snipet
1 Black
2 Rough
3 Smooth
4 Yellow
5 Texture
ColorNamesTbl: IDColor, Color
1 Yellow
2 Black
TextureTbl: IDTexture, Texture
1 Rough
2 Smooth
Query needed: Somehow pull out the words Yellow or Black from the file name (FileNameTbl) and get the IDColor that will be appended to original FileNameTbl.
Then I would like to do the same thing (hopefully simultaneously) for the texture.
I'm stuck. I've done a query with the inst function, bascially running a new update query for each field in my color table, but that was tedious.
Any help is appreciated.