Hello,

I want to create a portal based upon a field which combines two fields.

Example:

Client nr: 1000 (Unique ID)

Status: 1 (Done)

Combined field: 10001 (Client nr & status)

Database 1 -> has the field "Combined field"

Database 2 -> has the field "Combined field"

Now I create the portal, but this portal only shows one record instead of all records basesed upon the field "Combined field"

It is probably a indexing problem!

Question:

Is there a way to make my situation mentioned above work?

OR (even better)

Is there a way to pull once all the records based on the "combined field" into a specified field?

Looking forward for your input.

Greetings,

Jukkie

Edited May 3, 200619 yr by Guest

Testing if the instant e-mail option works combined with our XWall exchange spamfilter/Firewall.

Edited May 3, 200619 yr by Guest

Your COMBINED FIELD should have the content

1000

1

as a return separated list. FMP sees each item in the list as a valid part of the key (or index) in the relationship. It's a powerful feature that was never documented.

Thank for your reply, but now it shows all records with client nr 1000 and not 1000 and 1.

Combined field is of the kind type "calculation"

The calculation: Client nr & "¶" & Status

This gives the result

1000

1

or

1000

0

Is this the way you mentioned?

Jukkie

What you describe should basically work, so it's probably an implementation problem. Some points to check:

1. Use a calc of "Client nr & "|" & status" - otherwise there's danger of ambiguity.

2. On the same point, check if status is consistently "0" or empty when not "1" - it doesn't really matter which, as long as it always the same.

3. Make sure the calc result is set to Text, on both sides.

Thanks a lot for your input.

I solved the problem two ways:

Option 1)

The calculation: Client nr & " " & Status

This gives the result

1000 1

or

1000 0

Option 2)

But I can also define into the portal settings that the relation is bassed on Client nr AND Status and this on both sides.

Thanks a lot.

Jukkie

Your profile says you are using version 6.

Option 2) can only work in version 7 and higher.