Re: Relationshi problem, not girlfriend related

In article <m873u2tcef1brvor6kebfs02fjums2amd2@xxxxxxx>, Renfer
<realsol@xxxxxxxxxxx> wrote:

Hi Guys,

I'm having a mental fart here and I can't get something to work.

Maybe brighter minds without gas can see what I am missing.

I have two tables one called Contact and one called Sequence.

Each contact will have one sequence "assigned" to it (although this
may change along the way. (many to one)

One Sequence will be assigned to many Contacts. (one to many)

So... I made a Primary Key in each table (unique values), created a
Foreign Key (not unique) in Contact table and linked it to the PK in
the Sequence Table.

I don't want the relationship to create records in either table. I
just want to link them so, for example, a found set of Contacts will
be assigned a Sequence named Alpha (which I will created seperately in
the Sequence Table

Can't get portals, related fields or Value Lists to work

It ain't working. What am I doing wrong?

Thanks,

Renfer
Rookie, hopeless FM Database Maker (sort of)

Believe me, FileMaker is *MUCH* easier to understand than any
girlfriend will ever be. ;o)


You're not far off. I think your problem is that you haven't got enough
Key fields.

You've got two relationships going between the two tables / files which
have different requirements (ie. a Sequence can have many Contacts
linked to it), so you will need two sets of Key fields - a unique
"Primary" and a "Foreign" for each relationship. The "Foreign" Key
fields can contain multiple data separated by carriage returns to give
a "One to Many" relationship.
eg.

Contacts
Fields: Key_ContactID {Unique}
Key_SequencesForThisContact

Relationship:
Key_SequencesForThisContact = Sequences:Key_SequenceID


Sequences
Fields: Key_SequenceID {Unique}
Key_ContactsForThisSequence

Relationship:
Key_ContactsForThisSequence = Contacts:Key_ContactsID



The Key_ContactsForThisSequence field might for example hold data like:

Contact01
Contact25
Contact18

which links the record to those three Contacts.



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
.