Problems with Lookup Field when Moving Documents to another site l

Here is the situation:

I have two SharePoint sites open in two Internet Explorer windows. Both
windows are to the Explorer View for Document Libraries on two separate
SharePoint sites. I can successfully drag and drop the documents from the
Explorer View in one library into the Explorer View in the other site library.

Both libraries have a column called "owner" which is a lookup column that
looking into the User Information table and displays the Display Name. On
each library this field is optional (not required). The default value is
blank.

Here is the problem:

After moving the documents I noticed that the "owner" field in the new
library does not contain the same name that was displayed as the owner in the
previous library (even if the same name is available in the owner field list
of the new library).

Example:

Old site Owner field = Bill Gates ... move docs .... New site Owner field
= George Bush

But there is yet another catch:

Even if the old site Owner field is blank (because it is an optional field),
when I move the docs to the new site, the docs will get a new owner.
Example:

Old site Owner field = <blank> ... move docs ... New site Owner field = John
Moore

This is weird since the Owner field on the new site is not required and
there is no default value (blank) so the entry is blank unless you select
someone from the list.

Any ideas?

We are running Windows SharePoint Services 2.0 with no service packs.

Thanks!

Engelbert
Tue Mar 28 12:08:17 CST 2006

You need in addition to the file copy to do a copy of the original Doc Lib
in Datasheet View and then copy also that information (or to be exact the
missing columns) into the Datasheet View of the new doc lib.

Engelbert

"Charles Simpson" <CharlesSimpson@discussions.microsoft.com> wrote in
message news:29AC4467-5EE0-4E88-8315-433136075E0B@microsoft.com...
> Here is the situation:
>
> I have two SharePoint sites open in two Internet Explorer windows. Both
> windows are to the Explorer View for Document Libraries on two separate
> SharePoint sites. I can successfully drag and drop the documents from the
> Explorer View in one library into the Explorer View in the other site
> library.
>
> Both libraries have a column called "owner" which is a lookup column that
> looking into the User Information table and displays the Display Name. On
> each library this field is optional (not required). The default value is
> blank.
>
> Here is the problem:
>
> After moving the documents I noticed that the "owner" field in the new
> library does not contain the same name that was displayed as the owner in
> the
> previous library (even if the same name is available in the owner field
> list
> of the new library).
>
> Example:
>
> Old site Owner field = Bill Gates ... move docs .... New site Owner
> field
> = George Bush
>
> But there is yet another catch:
>
> Even if the old site Owner field is blank (because it is an optional
> field),
> when I move the docs to the new site, the docs will get a new owner.
> Example:
>
> Old site Owner field = <blank> ... move docs ... New site Owner field =
> John
> Moore
>
> This is weird since the Owner field on the new site is not required and
> there is no default value (blank) so the entry is blank unless you select
> someone from the list.
>
> Any ideas?
>
> We are running Windows SharePoint Services 2.0 with no service packs.
>
> Thanks!