Container Field

[Brad]

I have 2 files in FMP 6.0.

1 is a subject file with names, addresses, etc...; with a unique
number for each person.

2 is a photofile with pictures and the same unique number for each
photo, corresponding to the subjects in the other file. The photo is
in a container field.

How can I match the photo with the subject by the unique number and
import the photo into the subject file with out losing any information
in the subject files? Any ideas?

Thanks
Brad

[Glenn Schwandt]

One photo in file 2 for each subject in file 1? If that is the situation,
create a relationship between file 1 and file 2 based upon the unique number
(if not already done). Create a container field in file 1. Find all
records. Put the cursor in the container field. Select "Replace
Contents..." from the Records menu. Select "Replace with calculated
result:". Select the container field in file 2 as the result (use the
relationship drop-down to select file 2 fields). Click "OK" and "Replace".

"Brad" <bjones@hrc.state.in.us> wrote in message
news:6f04436a.0309091209.1eb5171a@posting.google.c om...

> I have 2 files in FMP 6.0.
>
> 1 is a subject file with names, addresses, etc...; with a unique
> number for each person.
>
> 2 is a photofile with pictures and the same unique number for each
> photo, corresponding to the subjects in the other file. The photo is
> in a container field.
>
> How can I match the photo with the subject by the unique number and
> import the photo into the subject file with out losing any information
> in the subject files? Any ideas?
>
> Thanks
> Brad