Multiple Conditions in a Portal Window

[benjaminb]

Is it possible to add a second (or more) condition to what you see in a portal window?

Can you have information displayed in a portal that are based on two fields? The first by an invoice number and the second by a category.

In other words, I would just like to show records that have the same number and category.

I thought it could be figured out simply but it's just not coming to me. Any help (even a hint) would be appreciated.

Thanks,

Ben

[SteveB]

Make your relationships based on calculations...that way, you can include anything you want.

[Steven H. Blackwell]

You have to construct the primary and foreign keys from calculations. That will enable you to "filter" the portal.

HTH

Old Advance Man

[lindbladej]

Any ideas about how to use the values in multikey fields as a match for primary and foreign keys for "filtering" a portal?

I have defined a relationship based on a global(primary key & "CR" & foreign key) in file1 to a calc (multikey1 & "CR" & multikey2) of the multikeys in file2.

I need to see related records that have *only* both the primary and foreign keys somewhere in the c_multikey1&multikey2 field. Right now this relationship gives me records with *either* value in c_multikey1&multikey2.

Thoughts?

Much thanks for any help

jeff

[Kurt Knippel]

You will need to match them on the same line, NOT seperate lines.

(i.e. PrimaryKey & " " & ForeignKey )

[lindbladej]

Unfortunately this doesn't work. I think for the Primary & " " & foreign relationship to be sucessful I would need to have a field in the target file that lists all combinations of the two multikey fields to match against. ie:

1A

1B

1C

2A

2B

2C

etc.

I'm not sure of a non-scripted way to create and maintain the values in this field.

thanks for helping me think through this!

[Kurt Knippel]

quote:

---

Originally posted by lindbladej:

Unfortunately this doesn't work. I think for the Primary & " " & foreign relationship to be sucessful I would need to have a field in the target file that lists all combinations of the two multikey fields to match against.

---

Yes, that is what you'll have to do. And it DOES work, I use this technique all the time.

What is the structure of your key fields? What are thier contents?

Knowing this I might be able to help you with the setup.

[lindbladej]

Wow thanks for your help!

I'm doing a staffing database that tracks part-time employees in various regions of the country able to perform specific jobs (or positions). I need to filter a portal to show who can do what in a particular region.

OK the two multikey fields I need to match against are t_Regions and t_Positions. The contents of these fields are text values with CR's betweeen each value. (check boxes with predefined value list entry) I have defined a field c_regions_Positions to be matched against. From your comments I assume this is the field that needs to have all possible combinations of Regions and Positions.

There are 15+ unique values possible for each field. I know I could do a script to loop through the Regions field for each record then for each selected region pick values from the positions field, concat then write it out to the regions_positions field. But this doesn't seem very elegant.

Do you have another idea or perhaps even a different way to think about relationships to this filter this info.

again thank you for your help.