How would you get about assigning a custom profile to a particular role in Drupal 6? For example if the user belongs to a role "TEAM1" and we want them to have a different profile than the rest of the users, how would you get about doing that? The profile must have basic information they can edit however it should also have some fixed fields that pull information from a database.
I am fairly new to Drupal however am a seasoned developer so if you can kindly spend some time explaining it I would greatly appreciate it. I know that one can utilize the Content Profile module however that throws me off a little since I will be pulling some custom data from the database also. I also know that one can make a custom node tpl file however just not sure how it all links together.
Thanks for your time and patience