My experience with SharePoint is not really sophisticated so please bear with me.
What I want to do is setting up a live-sync between a SharePoint list and a database table. This live-sync should be updating both ways, so if I change something in the list it should write back the changes into the database table and vice versa.
In addition the SharePoint list shouldn't show every column of the database table, but just 3 or 4 of them (like if I'd do a SELECT on specific columns and not a SELECT *).
The actual use-case for this would be a custom dictionary that I made. People can submit their own suggestions, but as they need to be approved first I had to think of something to flag those submissions. I decided to go with a "bit" column in MSSQL that is either "0" for not approved yet or "1" for approved.
As I don't want to have anyone screwing around in the actual database, I wanted to go for that SharePoint list. The guys who approve suggestions just get to see the important columns (original word, translated word, status) and can work it from there. If they decide to rephrase a suggestion or correct a typo or something they can just do it on the fly and after they've finished they set the status to 1 and everything is back in the Database and ready to go instantly (as the DB is queryied by an AJAX Livesearch).
Is such a thing possible with SharePoint? I'm happy over any suggestion you guys can offer me, so fire away ;-)
best regards, daZza