how to evaluate whether there is a related record?

[jiehuang001]

I have two related file, fileA.fp5 and fileB.fp5. Now I am creating a button in fileA.fp5, when there is a related record in fileB.fp5, then display the related record so that I can update it. When there is no related record in fileB.fp5, then display a blank form so that I can add a related record.

Please help.

Thanks.

Jie Huang

 

[lebisol]

create a "lookup" field(s)....if the records are related the fields will be populated ..if not they will remain emty. better yet,Look into using portals.
All the best!

> need more info?
:: don't click HERE ::

 

[Schlogg]

Let's assume your child relating field LinkB.
In a script ->
if(Relationship::LinkB)
the record exists
else
it doesn't
end if

Cheers,
Paul J.

 

[WKLawrence]

In the script, use an if statement with the calculation:

Count(TheNameOfARelatedFieldYouWantToCheck) > 0

If there are no realted records, it will return zero, If there are, it will return the number of related records.