Good morning !
Why does my keylookup returns false?
I want to connect my company_code [vt_employee] to the company_code[vt_company] to get the company name.
Here is my scenario:
1. I am using virtual tables from a mysql engine and successfully created a db in Lianja. The MySQL db itself had indexes.
2. Since the keylookup deals with indexes, I was thinking that perhaps my indexes were not incorporated to the virtual tables so I added the indexes in the console.
ALTER TABLE vt_employee ADD FOREIGN KEY (company_code) TAG company_code;
3. Added keylookup code :
(Get Data Map)
keylookup("vt_company", "company_code", "{}", name)
(Set Data Map)
keylookup("vt_company", "name", "{}", company_code)
Did I misunderstand the process or did I miss something? It doesnt work on the grid and on the form. I hope you can help me out with this. Thank you very much
Bookmarks