Create a portal based upon two combined fields

[Jukkie]

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, 2006 by Guest

[Jukkie]

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

Edited May 3, 2006 by Guest

[IdealData]

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.

[Jukkie]

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

[comment]

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.

[Jukkie]

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

[comment]

Your profile says you are using version 6.

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