i want to link my new table to MSP_Projects table

[ProjectServer2007Developer]

1) i want to create my own table in project server 2007 database ( say
contarct table that contain ContractId,ProjectID), then i want to link this
table to MSP_Projects table,how?
2) then i want create custom list in PS2007 with new custom field then i
want to store this fields in my new table ,how it programmatically? ,
3) how can i query my new table to use result query in project server 2007?
4) i really want how i create my own .aspx page with my interface but with
the same style of PWA and workspace (Master page).and then i want to import
it to PS2007,how all it?
if there any suggestions or ideas will help me,plz display it quickly

 

[Stephen Sanderlin]

1) The answer to this question is the same as it has been in the last
two posts... you can create a custom table in the RDB and join it using
SQL -- however this information will NOT display in Proejct Server.
2) This answer is also the same... You would need to design some sort of
import mechanism, either using SQL or something else.
3) Same as your last question that I answered -- you cannot unless you
want to create some sort of import mechanism to import the data into a
custom field...
4) Can't help you here... MS doesn't support this. However, you can do
it like you would any other application -- simply examine the master
page, existing ASPX pages, and the source of generated pages to figure
out placeholder/class/id names, and design your own page to use them.
Very labor intensive.

--
Stephen Sanderlin
Principal Consultant
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read my blog at: http://www.projectserverhelp.com
Join the community at: http://forums.epmfaq.com

 

[ProjectServer2007Developer]

thanks about your reply,but i've comment
1)you told that information of custom table will NOT display in Project
Server but when you answered my second question you advised me to use som
sort of import mechanism to these information in custom list which i'll use
it in PS 2007 how is it?
Thanks & Regards

 

[Stephen Sanderlin]

Out of the box, Project won't read data from additional tables you add
to its databases. However, you can create a module to read the data from
the DB and write it to a custom field in PS07.

My response to your first question assumes you would want to join this
information using SQL... for that purpose, you could make a custom table
in the DB and then simply join the data. I assumed your question was
asking how to join this data using SQL since you mentioned table names
-- if that was wrong, please accept my apologies.

Regardless, if you want it to display in PS, you'll need to make an
import mechanism, as my second response states.

--
Stephen Sanderlin
Principal Consultant
MSProjectExperts

For Project Server Consulting: http://www.msprojectexperts.com
For Project Server Training: http://www.projectservertraining.com

Read my blog at: http://www.projectserverhelp.com
Join the community at: http://forums.epmfaq.com