Jump to content

Create a portal based upon two combined fields


Jukkie
 Share

This topic is 5688 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 by Guest
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5688 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.