October 31, 200124 yr 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?
October 31, 200124 yr 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
Create an account or sign in to comment