programming full time

I am transfered to the programming departement (if such a thing exist in my compagny hehe)

Next project:
product management in sharepoint portal, ASP, SQL 2008

Since we do not sell software i will publish here the best code or most difficult one
There sill be a lot of ASP to manage sharepoint
My goal is to have 1 database in read only in our software that manage production
the sharepoint database
and a custom database to link theses 2 and add custom columns

Everything will have to be dynamic because it's a new project to manage our products and will evolve a lot on the way

The challenges will be:
1. security, using LDAP logon
2. dynamic query that will be able to read and write in 3 different database with on query or stored procedure (obviously a view will not do it, since it was created to read only)
3. implement an interface to edit database with some column in read only (there again a grid will not do it, because of the nature of the link between 3 different database and update we will need)
4. make theses data easily available in excel for everyday uses

the goal of this is to make product evolve without always basing the next generation on the old generation

the next generation / production of a product will be base on a model, that will evolve, and so on

each product will need:
discussion board
document models
drawing list for pieces
drawing models
diagrams for reprogramming models
programming sub that will be reusable for each automates
tag list for each categories for programming

all of this linked to 2 already existing databases