I am new to Zoho and it appears to be the perfect solution for my small business. We have a current database which we do not use the majority of the features but pay a lot of money, therefore looking for a simple cost effective solution. I have export the tables into 3 Excel documents; 1 contains company details, 1 contains the contact details and the other the machine details. I want to setup a database that contains 3 forms for each of the tables with a one to many relationship, for example 1 company can have many contacts and 1 company can have many machines. In the Excel documents I have a field with a number which links the 3 documents - company ID. So on machine document will have the company ID against each machine linked to the company.
Now I have figured how to create forms and sub-forms in Zoho or forms and use lookup field pointing to another table which is perfect for the layout, however I can I import my current data into this format and making sure they link?
Please Help!!!