interchangeability

interchangeability

Let's say:

I have a database as well as numerous spreadsheets and forms all basically holding the same information in different views.

I want to be able to edit any entry on any document and have that information follow back to all associated forms, databases and spreadsheets.

Some days I want to edit in a spreadsheet format without doing it in database view.  Some days I want to edit in database view and know that the information will automatically go on the spreadsheet.  Etc.

Google docs doesn't have a database.  Zoho has a database but forces the user to input new information using the database view.  Ugh.