Whats the best way to do this?:

Users from different companies need to log into a web site. I want to add
the users company name, address etc to their profile. However I want the
company details to be stored separately (i.e. in a separate table in the
database) as more than one person could be from the same company.

I though that if I set up the company table and add the companyID to the
user profile that might do the job?

JJ

You can have the user pick a company when they sign up for an account. That
would work rather nicely. Store the companies in a table and then link it to
the user. You can create a separate user table rather than store all in
profile, but you can also use the key of the company table in the profile
table, to link them.

If you are trying to brand it, use an HTTP handler with the brand as the
first dot, like microsoft.mycompany.com. You can then have the handler set
the application and use different applications in the aspnet_application
table. You can then skin the site with their look and feel. If HTTP handler
is too much of a pain, you can create the entire functionality of the site
in libraries, GAC them and add different branded sites (same site, different
skin). It serves the same purpose.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com

********************************************
Think outside the box!
********************************************
"JJ" <(E-Mail Removed)> wrote in message
news:uK$(E-Mail Removed)...
> Whats the best way to do this?:
>
> Users from different companies need to log into a web site. I want to add
> the users company name, address etc to their profile. However I want the
> company details to be stored separately (i.e. in a separate table in the
> database) as more than one person could be from the same company.
>
> I though that if I set up the company table and add the companyID to the
> user profile that might do the job?
>
> JJ
>

Hi Gregory.
Thanks for you reply.

I don't actually want the user to see the other companies. as they shouldn't
see who else is a 'client'. This is a bit of a pain as it means the admin
has to set the users company later (unless theres another way of doing
this - I wish there was but I cannot think of one).

Its not a case of branding, useful though your information is - just a case
of only allowing a company to see their own projects.
JJ



"Cowboy (Gregory A. Beamer)" <(E-Mail Removed)> wrote in
message news:EBD211DE-A6B6-4284-99B2-(E-Mail Removed)...
> You can have the user pick a company when they sign up for an account.
> That would work rather nicely. Store the companies in a table and then
> link it to the user. You can create a separate user table rather than
> store all in profile, but you can also use the key of the company table in
> the profile table, to link them.
>
> If you are trying to brand it, use an HTTP handler with the brand as the
> first dot, like microsoft.mycompany.com. You can then have the handler set
> the application and use different applications in the aspnet_application
> table. You can then skin the site with their look and feel. If HTTP
> handler is too much of a pain, you can create the entire functionality of
> the site in libraries, GAC them and add different branded sites (same
> site, different skin). It serves the same purpose.
>
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
> http://gregorybeamer.spaces.live.com
>
> ********************************************
> Think outside the box!
> ********************************************
> "JJ" <(E-Mail Removed)> wrote in message
> news:uK$(E-Mail Removed)...
>> Whats the best way to do this?:
>>
>> Users from different companies need to log into a web site. I want to add
>> the users company name, address etc to their profile. However I want the
>> company details to be stored separately (i.e. in a separate table in the
>> database) as more than one person could be from the same company.
>>
>> I though that if I set up the company table and add the companyID to the
>> user profile that might do the job?
>>
>> JJ
>>
>

I think I'll do as you say and link the company table to the user profile.
Thanks,
JJ
"JJ" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Gregory.
> Thanks for you reply.
>
> I don't actually want the user to see the other companies. as they
> shouldn't see who else is a 'client'. This is a bit of a pain as it means
> the admin has to set the users company later (unless theres another way of
> doing this - I wish there was but I cannot think of one).
>
> Its not a case of branding, useful though your information is - just a
> case of only allowing a company to see their own projects.
> JJ
>
>
>
> "Cowboy (Gregory A. Beamer)" <(E-Mail Removed)> wrote in
> message news:EBD211DE-A6B6-4284-99B2-(E-Mail Removed)...
>> You can have the user pick a company when they sign up for an account.
>> That would work rather nicely. Store the companies in a table and then
>> link it to the user. You can create a separate user table rather than
>> store all in profile, but you can also use the key of the company table
>> in the profile table, to link them.
>>
>> If you are trying to brand it, use an HTTP handler with the brand as the
>> first dot, like microsoft.mycompany.com. You can then have the handler
>> set the application and use different applications in the
>> aspnet_application table. You can then skin the site with their look and
>> feel. If HTTP handler is too much of a pain, you can create the entire
>> functionality of the site in libraries, GAC them and add different
>> branded sites (same site, different skin). It serves the same purpose.
>>
>> --
>> Gregory A. Beamer
>> MVP; MCP: +I, SE, SD, DBA
>> http://gregorybeamer.spaces.live.com
>>
>> ********************************************
>> Think outside the box!
>> ********************************************
>> "JJ" <(E-Mail Removed)> wrote in message
>> news:uK$(E-Mail Removed)...
>>> Whats the best way to do this?:
>>>
>>> Users from different companies need to log into a web site. I want to
>>> add the users company name, address etc to their profile. However I want
>>> the company details to be stored separately (i.e. in a separate table in
>>> the database) as more than one person could be from the same company.
>>>
>>> I though that if I set up the company table and add the companyID to the
>>> user profile that might do the job?
>>>
>>> JJ
>>>
>>
>
>