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:
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 " ;
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.