How to create a counsellor case notes management system in SharePoint using BCS

I finally got around to
configuring Business Connectivity Services (BCS) for SharePoint 2010.

I am really excited about the applications of BCS in the education context.
I have created a simple Student Counselor Case Notes Management System, but I
plan to build the following educational applications using BCS.

1. Parent – Teacher Interview Booking System &

2. Locker Management Sytems.

So if you have a SharePoint 2010 and you are a school with the need for the
above systems, keep an eye out for future posts.

How to create a Counselor Case Notes Management System

I won’t repeat information that has already been published on this topic so
here are the links you will need to get started.

1. What is Business Connectivity Services http://technet.microsoft.com/en-us/sharepoint/ee518675

2. Setting up your first BCS http://fabiangwilliams.wordpress.com/2010/04/16/how-to-create-configure-consume-sharepoint-2010-secure-store-in-business-connectivity-services/

This is probably the best post on setting up BCS for SharePoint 2010.
Fabiang doesn’t talk through any errors. I had an awful time trying to work out
an authentication issue.

Solved the issue through reading through the following posts

http://social.technet.microsoft.com/Forums/en-US/sharepoint2010customization/thread/be9c35ed-a97e-44d4-90f7-44da6bd46e9a/

Here are my screen shots for the Student Counselor Case Notes Management
System

Notice that my form has been manipulated using InfoPath
2010.