Multiselect / Subform

Hi all,

I am trying to customize our Zoho installation, in order to make usage as easy as possible. As part of our companies needs, I created a custom module (containing Song information) which needs to be combined with the Contacts (Song Writer) in a manner that allows a many to many relationship. My current build uses a multi-select tool to do so, resulting in a LinkedModule with the specifics of each Writer's share on a song, in which we can store his share, along with information regarding contract status etc.

The problem is that entering these shares manually requires a lot of clicks. I tried to automate the easy cases using code (get number of composers from data, divide 100 by this number, update all shares), but the scripts do not allow to pull related records of custom modules.

Alternatively, subforms allow easier input of these numbers, but as far as I can see the only way to check subform data is by manually opening every record. Additionally, relationships created this way do not appear to show up as related items.

Suitability of the options depends on the user type (is he/she entering Song Details or creating contracts for Writer X), but neither can be used easily for both. Is there a way to have the subforms and linking module to be synchronized somehow? Or alternatively be able to query on subform fields over all records in a module?

Thanks in advance