I hope someone out there can help me. Envision this ... an accounts receivable / accounts payable super simple spreadsheet, to ultimately be maintained by someone who is not computer literate. It needs to be accessible from within the cloud (Google Spreadsheet, some other free SaaS product, etc) with columns similar to the following:
Company Date From To Amount Payment Type Details
The quandary is that I need certain columns (Company, From, To, etc.) to be completely idiot-proof and only be populated via a multiple choice dropdown from a list. It needs to be relational in the sense that is is reasonably simple to add additional company names to the list, but if there is a typo in one, or the name is altered, it retroactively updates all occurrences (a la relational database).
Microsoft Access does what I need, but I'm looking for something with a simpler UI and also that is in the cloud. With Microsoft Excel, I was able to figure out how to do data validation via a predefined list, but changes to an item in the list don't retroactively update all exiting occurrences (i.e. there's no relationship). Am I doing something wrong there?
I'm looking for something that lets me suuuuuper simply create dummy-proof tables. I just need it to be even more dummy-proof by not accepting invalid data. Does anything like that exist in the cloud???