Hi there,
Historically we've only added keywords to our productions on the highest level, which for us is by festival.
We are looking to add a few more going forward, such as 'choral', 'orchestra', 'chamber' for our music festival and 'biography', 'poetry' etc for our literature festival so that we can segment messages based on the types of productions people are attending.
Ideally i'd like to pull out a list of productions historically and do a piece of work to add keywords to these too on mass in our SQL server to update the relevant production IDs with the correct keyword ID but can't seem to find the table that links productions to their keywords. Does anyone know where these 2 things are linked?
Thanks,James
Hi James,
The table is TX_INV_TKW where the inv_no is a perf_no or prod_no etc.
Cheers,
Kevin
Perfect, thanks Kevin!