We have been evaluating Zoho creator and find it has all the features we need. However we have been trying to import our data into Zoho creator from our relational database and do not see how we can recreate the relationships in Zoho with existing data?

We have exported all the relevant tables to excel files and have imported them in Zoho creator, but cannot find out how we can recreate the relations between the individual files (example: between customer and addresses, or between customer and bookings). Since there are a couple thousand records we cannot do this by hand for each single record.  Each excel file has a unique ID field and a foreign key field for the related table. From what we can see, when creating a subform, creator makes it's own internal connection between related records. Maybe there is a way to create a deluge script that does the lookup between ID an and foreign key and then updates the Zoho creator relationship? Or there is an easier way, to import the files and keeping their relationship which we haven't seen?

So we would be most grateful if someone could show us how to import our data and create the corresponding relationships. 

Thanks