Multi-Select Lookup Limitation

Multi-Select Lookup Limitation

Hi

We are new to Zoho and have bought an enterprise licence and started creating a simple database. The problem we face is that we have one to many module called SUPPLY hung off the Lead and then from this module we want 3 one to many  modules hung of each Supply which are Contract, Rates & Recordings - so one supply can have multiple rates and multiple recordings and multiple contracts. Firstly can this be done as it seems to me to be a very simple database requirement, secondly if it can't be done can anybody think of a work around that wouldn't involve including rate, recordings and conrtacts as fields within the supply module?  

I'm sure you understand what i'm asking but here is a simple table diagram below with what I want...sorry for the crudeness of the drawing...!!:

Thanks in advance.

Dave