In my keywords "cross-reference table":
Code: Select all
tblrelation_createObject "handler to keywords"
tblrelation_set "handler to keywords", "type", "many-to-many"
tblrelation_set "handler to keywords", "left table", "handler"
tblrelation_set "handler to keywords", "left table key", "id"
tblrelation_set "handler to keywords", "cross-reference table", "handler_keywords"
tblrelation_set "handler to keywords", "cross-reference table key for left table", "handler_id"
tblrelation_set "handler to keywords", "cross-reference table key for right table", "keyword_id"
tblrelation_set "handler to keywords", "right table", "keywords"
tblrelation_set "handler to keywords", "right table key", "id"
tblrelation_set "handler to keywords", "order by", "handler.name"