Dear all.

It pass some time when I make my last job in a FileMaker 9 and now I again
get request to make a new app. in it.

But I have one problem which is common at beginners. I know that this is
common technique to do it but I can't remember how to do it.

Problem:

I have two tables: Companies and related table Contact_Persons

I have a Layout which is showing a Information's about companies and on this
layout a add a portal which is showing two fields from related
Contact_Person table. I also add on this a layout a fields which is showing
additional data from Contact_Persons.

What I want is that when I select a person (row) in a portal, that
additional field show information's about selected person.

Any idea?



With best regards

Zarulja

Hi.


I try this:

I add a field called Selected_Person_ID in a table Companies (type=number).

In a relationship graph I make a copy of a table Contact_persons and I
called Selected_contact_person_from_portal.

I connect fields in relationship graph: Companies: Selected_Person_ID =
Selected_contact_person_from_portal:ID_Person

I make a script in which I added:

Set Field:[ Selected_contact_person_from_portal:ID_Person; Companies:
Selected_Person_ID]

Commitrecord/Request[No dialog]

So when I select a row in a portal and trigger a script, in additional field
nothing happened (no change in for example "Department" field




With best regards

Zarulja

"Martin ?rautmann" <t-usenet (AT) gmx (DOT) net> wrote

In article <jb7jmm$2v4$1 (AT) ss408 (DOT) t-com.hr>, "Zarulja"
<zarulja33 (AT) hotmail (DOT) com> wrote:

Just a quick idea - check that the additional fields (Department, etc.)
are using the correct Relationship. They should be using the new
Relationship, not the Portal's one. It should be easy to tell since the
fields will display data from the first Portal Row's record if it's using
the wrong Relationship.

Helpful Harry )