Auto fill in colums trough foreign key relationship

Hi,
I have a table users where there is a user_id and an department column.
Also i have a table called KRS where there are the same columns, when a userid is given i want to auto fill in the departmentid,
Can someone help me with this?
Cheers WimYou want help creating a denormalized database?

[sigh...]

If you absolutely need to do this, you can accomplish it through an INSERT trigger on your KRS table.

Why are you duplicating data like this?|||You want help creating a denormalized database?

[sigh...]

If you absolutely need to do this, you can accomplish it through an INSERT trigger on your KRS table.

Why are you duplicating data like this?I keep trying to shoot myself it the foot, but the rifle wobbles when I pull the trigger. Can one of you guys hold it for me?

I actually thought about trying to formulate a reply to this question, but nothing I wrote seemed fit to post. I'm thinking that a VIEW would make life a lot easier in the long run, what do you think?

-PatP

Auditing Tool

The department here is looking for a 3rd party auditing tool that can monito
r
the SQL 2000 data base for changed, deleted or added records. One utility
available is Apex SQL
Log that costs about $700.00. Anyone know of this or any other such utility
?
Thanks for everyone being there to help.Hi,
See Logexplorer from www.Lumigent.com
Thanks
Hari
SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:86F241F5-03E4-4491-ACEF-5AC5943628D8@.microsoft.com...
> The department here is looking for a 3rd party auditing tool that can
> monitor
> the SQL 2000 data base for changed, deleted or added records. One utility
> available is Apex SQL
> Log that costs about $700.00. Anyone know of this or any other such
> utility?
> Thanks for everyone being there to help.
>

Auditing Tool

The department here is looking for a 3rd party auditing tool that can monitor
the SQL 2000 data base for changed, deleted or added records. One utility
available is Apex SQL
Log that costs about $700.00. Anyone know of this or any other such utility?
Thanks for everyone being there to help.
Hi,
See Logexplorer from www.Lumigent.com
Thanks
Hari
SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:86F241F5-03E4-4491-ACEF-5AC5943628D8@.microsoft.com...
> The department here is looking for a 3rd party auditing tool that can
> monitor
> the SQL 2000 data base for changed, deleted or added records. One utility
> available is Apex SQL
> Log that costs about $700.00. Anyone know of this or any other such
> utility?
> Thanks for everyone being there to help.
>

Auditing Tool

The department here is looking for a 3rd party auditing tool that can monitor
the SQL 2000 data base for changed, deleted or added records. One utility
available is Apex SQL
Log that costs about $700.00. Anyone know of this or any other such utility?
Thanks for everyone being there to help.Hi,
See Logexplorer from www.Lumigent.com
Thanks
Hari
SQL Server MVP
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:86F241F5-03E4-4491-ACEF-5AC5943628D8@.microsoft.com...
> The department here is looking for a 3rd party auditing tool that can
> monitor
> the SQL 2000 data base for changed, deleted or added records. One utility
> available is Apex SQL
> Log that costs about $700.00. Anyone know of this or any other such
> utility?
> Thanks for everyone being there to help.
>