I'm running MOSS 2007
I currently have a BDC query pulling a list of all my company's clients out of a program's SQL database that we use. Im using this list to show a list of which tech is in charge of which customer on my sharepoint site. The only part that is pulled out of
the database is the client name, the rest is added in the list.
Currently when you click on the clients name, it takes you to their BDC Profile page, which has all the info pulled out if the SQL database, like phone#, email address, etc.
I understand you can customise the BDC Profile pages, as I've already done that.
Now, I want to be able to show some more info on the page, stuff that isnt in my SQL database, eg a link to their folder on our server, some more contact details, etc.
How would I go about this? I want the query that pulls that info out to be dynamic, i.e only show info for that certain customer.
I've thought about making a separate list on the ssp site, as I don't seem to be able to access anything from the proper sharepoint site when I'm at the profile page. I don't know how to only show the info for the current customer, though.
Can anyone shed some light on this for me?
It'd be much appreciated :)
View Complete Post