We're trying to convert an older access app with a sql server back end (with many tables) to Sharepoint. There are entry forms, update forms, look up forms, reports, etc
the 2 questions I have are:
1. How can I create a dropdownlist that gets its items from a SQL table?
2. How can I create a form that, when filled out, puts items into multiple tables?
Basically, I'd like to know if any of this is possible in 2010, and does anyone have any tips on where to start?
View Complete Post