AnsweredAssumed Answered

Populating Related Fields Based on Calculation

Question asked by chrislines on Jan 27, 2016
Latest reply on Feb 3, 2016 by chrislines

Good evening Members

 

Seeking help please on populating related fields based on a calculation.

 

I have 'tblHeight' with fields kp_HeightID, HeightGroup, HeightClass, HeightName, and HeightDescription.


I have 'tblBonsai' with several fields including kp_BonsaiID, kf_HeightID, number field BonsaiHeightNow, and calculation BonsaiHeightNowCalculation. This calculation determines HeightClass using the following case statement:

 

Case (

BonsaiHeightNow < 9 ; " Poppy-Seed " ;  

BonsaiHeightNow < 11 ; " Fingertip " ;  

BonsaiHeightNow < 16 ; " Palm" ;

BonsaiHeightNow < 21 ; " One-Handed " ;

BonsaiHeightNow < 26 ; " One-Handed " ;

BonsaiHeightNow < 47 ; "One-Handed " ;

BonsaiHeightNow < 92 ; "Two-Handed " ;

BonsaiHeightNow < 123 ; "Four-Handed " ;

BonsaiHeightNow < 153 ; "Six-Handed " ;

"Imperial"

)


Result is text. The case statement seems to work and gives the results that I hoped for.


kf_HeightID, HeightGroup, HeightClass, HeightName, and HeightDescription reside in a tab control on layout 'Bonsai_Detail'.


So, I enter a number in BonsaiHeightNow. I get the case result text in BonsaiHeightNowCalculation.


Can I make the case result text populate HeightGroup, HeightClass, HeightName, and HeightDescription with the related data? How would I do it?


Thanks in advance for any assistance.

 

Regards

 

Chris

Outcomes