Please bear with me as I am learning, I may not use the correct terms
for this...

File#1 is imported from a csv and has one field (MyReferenceNumber)
which I want to use as the key to link to a second file.

File#2 I will create this file with a single table having about 10
fields. A few of these common to file#1, a few existing only in
file#2.

Goal: For avery record in #1 where "MyReferenceNumber" has a value>0
import all other fields from file#1 into matching fields in file#2.

Ideally, file#1 should act read-only when working in file#2, ie I
don't want to edit common fields in file#2, only those unique.

Any help much appreciated.

Andrew L.

In article <5j9nn15il08j1bu422hfg0r799fnvnqndu (AT) 4ax (DOT) com>,
Andrew L. <no-one (AT) nowhere (DOT) net> wrote:

From your description, it sounds like all the data you want to import
into both Filemaker tables now resides in the CSV file. In that case, I
would do the import into each of the two FileMaker tables direct from
the CSV file, first into one, then into the other. Details:

1. Define the fields you want in each of the two FileMaker tables.

2. Import the desired fields from the CSV file into each of the two
FileMaker tables.

3. If not already done, define the relationship(s) between the two
FileMaker tables.

4. The rest of what you want to do is all done in Filemaker: Layouts,
including display of related fields individually and in portals, etc.

Bill Collins

--
For email, remove invalid.

On Wed, 16 Nov 2005 22:25:28 GMT, Bill
<bbcollins (AT) invalid (DOT) earthlink.net> wrote:

Bill:
I only want to import a few fields from #1-->#2. The rest will be
unique to #2. I don't want to import from csv to #2, but to have a
direct relationship between #1 and #2 based on the ID. The important
thing is that I only want to import records where the
"MyReferenceNumber" exists>0 in #1.

Here's a little more info which might help:
The csv is an exported file from an online database of live music.
Within that csv is a field, "MyReferenceNumber". File#1 is created by
imported all fields from the csv. Some of the performances in this csv
I have archived, and I want a database which provides info about the
local archive (disc type, label, format, locatin etc...). I want to
use "MyReferenceNumber" as the ID to link the 2 files. I will add a
ref# to the csv for only those files I have archived, and want some
fields from records where ref# exists to be automatically imported. Is
that clearer?

In article <vpcnn1tl3v2qpfaiicldr54suhjas0mgl7 (AT) 4ax (DOT) com>,
Andrew L. <no-one (AT) nowhere (DOT) net> wrote:

OK. Try this:

Import the CSV into #1.

Do a Find in #1 for MyReferenceNumber > 0

Import from #1 to #2. Only the records in the Found Set will be imported.

Alternatively, import them all into #2, then do a FIND in #2 that omits
those with MyReferenceNumber > 0, then delete the Found set.

Bill

--
For email, remove invalid.