Active fields only shown in Portal

[Shane]

I' Like to show records in a portal that match a relationship, but only if they also are marked as active in a field called STATUS in the related file. Is there any way to do this?

[LiveOak]

To do this you need to modify your keys to create what is called a compound key. If your status field is STATUS, the new key might look like:

NewRelatedKey (calculation, text, indexed) =

STATUS & OldKey

In your master file, the key might look like:

NewMasterKey (calculation, text, indexed) =

"Active" & Oldkey

You are creating a key based upon two fields.

-bd