Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:modifications:popup_relations [2014/10/09 14:55] swarnat [Explanation of modification] |
en:modifications:popup_relations [2014/11/03 10:52] (current) swarnat [Create a Relation] |
||
|---|---|---|---|
| Line 29: | Line 29: | ||
| CREATE TABLE IF NOT EXISTS `vtiger_popup_relation` ( | CREATE TABLE IF NOT EXISTS `vtiger_popup_relation` ( | ||
| `id` int(11) NOT NULL, | `id` int(11) NOT NULL, | ||
| - | `src_module` varchar(30) NOT NULL, | + | `src_module` varchar(30) NOT NULL, |
| - | `src_field` varchar(50) NOT NULL, | + | `src_field` varchar(50) NOT NULL, |
| - | `module` varchar(30) NOT NULL, | + | `module` varchar(30) NOT NULL, |
| - | `search_key` varchar(50) NOT NULL | + | `search_key` varchar(50) NOT NULL, |
| + | `search_value` varchar(50) NOT NULL | ||
| ) ENGINE=InnoDB ; | ) ENGINE=InnoDB ; | ||
| Line 155: | Line 156: | ||
| | src_field | You get from the PopUP URL | | | src_field | You get from the PopUP URL | | ||
| | module | You get from the PopUP URL | | | module | You get from the PopUP URL | | ||
| - | | search_key | Which column in the related module should used to search | | + | | search_key | Which field in the related module should be used to search | |
| - | | search_value | Which columnvalue of the record you modify should be used | | + | | search_value | Which fieldvalue of the record you modify should be used | |
| <WRAP center tip 100%> | <WRAP center tip 100%> | ||
| === Example === | === Example === | ||