Portal question.... what if null

[lonesomejubilee]

Hi,

I have a question about portals. I have a portal that looks up an employee's information from one table based on an employeeID. But what if that ID does not exist? Is there anyway to make it return a message instead of just being blank?

Vandy

[Lee Smith]

This may be the long way around, AND the way I would do it in V6, but create a new calculation in your file and use your current Relationship and this calculation

Case(IsValid(YourRelationship::YourFieldHer)=0, "There is no relationship for this file", "")

HTH

Lee

[-Queue-]

Better to use IsEmpty since IsValid has more meanings than simply 'related records do not exist.' It seems that Lee is using it to test whether the related file can currently be found, which is proper usage. But the question appears to ask for whether a related record exists.

Case( IsEmpty(YourRelationship::ID); "There is no related ID."; YourRelationship::YourField )

[Lee Smith]

Hi JT, welcome back.

You are correct that was what I was doing. However, I agree that the IsEmpty is a better function to use here.

Thanks for correcting me.

Lee