Is it possible to create a lookup field that accesses records from multiple modules?
SCENARIO
My Company is a Managed Service Provider (MSP). We offer IT support to multiple companies (Accounts), each Account has about 25 individual "IT systems" (WiFi, TV, PBX, etc), each with their own 3rd party vendors.
Because Zoho has a limit on Look-up fields, I had to get creative when it came to linking all the the Accounts with the 25 or more 3rd party vendors. I used Linking Modules. So each system has it's own record in a system specific module (i.e. PBX Module, WiFi Module, etc)
Now, I want to link my Deals to the Linking Modules made previous (PBX, TV, WiFi...). I am curious, can I just make a lookup field that can look across MULTIPLE modules?