Hi All,
I am trying to create a bit of SQL that will give me an output showing which productions have a production description TKW attached but I can't work out which table would give me that detail.
Any help greatfully received
Ean
I'm not sure I explained the above very well so I'll try and expand.
We have created a TKW Category called performance description and then within that category a number of TKW entries that define a production interest base (e.g comedy, children etc)
These interests are then attached to productions under keywords. We now want to be able to produce a list of which productions have which keywords but I can't work out which table stores that info.
Hope that makes a bit more sense LOL
I think it's something like TX_INV_TKW (not at my desk). Remember that keyword are inherited down the Production Element tree. I have an old view that I use to pull that info together for me that I could dig up.
That absolutely did the trick thank you Gawain.