Ok, here is what i have, and I am hoping that you guys will have some good insite for me.
I use Dabble DB now for this, and it works, it is just kind of weird at times, and if we ever hire someone new, it is a long process to get them up to speed.
Anyway, Here is an example of what I have going on. I have a data base with member info. It contains all their business info, name, address, acc# etc... I then get reports from my vendors with my members sales. With dabble, I can import the excel spreadsheet and relate the acc# from the Member info data base to the newly upload data base to one another.
Now, here is what dabble would do for me. When I would relate (or link to entry ,Dabble lingo) I would automatically create a new column in the member info data base and input months sales that i just recieved from the vendor.
All, that I have to do everything month is upload the spreadsheet into dabble and relate the acc# to acc# and it does everything else.
I am hoping that this is able to do the same, because I like the ease of use with ZOHO.
Thanks in advance and sorry for the extra long post
Cory