Problems with a portal

[martinw]

Hi all,

I have a portal that brings up records from a second database thru a relationship, and it works fine. I get all records from 2nd DB where status="live". But now I want it to use one more criteria for the selection of the records shown. I also want to match ClientID between the two DBs.

So I want to show all records from 2nd DB with status="live" and ClientID=ClientID.

Is it possible? How do I do?

Thanks,

Martin

[andygaunt]

In your related database, create a calc field (result of text)

Status & ":" & Client ID

In your main file you have two global text fields.

1 for status (gStatus) and 1 for client id (gClientID)

Now you have a calculation (result of text) that is

gStatus & ":" & gClientID

Your portal uses these two calcs for its relationship

HTH