I am creating a class registration database for a nonprofit, and Zoho looks very promising. I have run into one stumbling block.
When creating a field of type "import data" you get a drop down interface showing all the values of a specified field in another table. You also get an option to "Show link for adding new value" Is there a way of getting the "link for adding new value" without creating a dropdown list?
I have a class registration database that contains a "parents" table and a "students class registration" table. In the "students class registration" form I ask the user to enter the "Parent's Account Number" in order to create a many-to-one relationship between "students class registration" and "parents." This is now working as intended with the dropdown, however I want to put the "students class registration" form on our website, and therefore I want to eliminate the dropdown that would publicly expose all of the parent account numbers. Instead I would like to use a field of type "single line" to enter the "Parent's Account Number" I use an "on validate script" to direct the user to click the "link for adding new value" if the "Parent Account Number" that is enterd does not exist.
I can use a "dummy" drop down to make the link appear on the page, but then it is not placed next to the field where I want it.
This is a long explanation,, I hope I have been clear.
Steve