Can I make the case result text populate HeightGroup, HeightClass, HeightName, and HeightDescription with the related data?
Short answer: Yes, you can do this.
Longer answer: What you should probably do instead is just establish a relationship between tblBonsai and tblHeight. Then you can simply show the related values on the current tblBonsai tab / layout. This is in keeping with basic database normalization principles - only store data in one place, rather than copying it across tables. (There are exceptions when this is either necessary or beneficial.)
I would also suggest you use a primary key for tblHeight rather than the name. That way, if the name ever changes, the relationship will remain intact.
Thanks Mike. Great help so far, but I remain unsure about my next step.
I do already have a (one-to-many) relationship between tblBonsai and tblHeight.
I can see, via LAYOUT mode, in the tab control on layout Bonsai_Detail the following related fields: HeightClass (yellow icon), HeightGroup (yellow icon), and HeightDescription (yellow icon).
I also see, via LAYOUT mode, in the tab control on layout Bonsai_Detail the following fields: BonsaiHeightNow (which is the field I use to enter number of centimetres) and BonsaiHeightNowCalculation (which determines HeightClass).
I think this follows your suggestion. Still, I can't figure out the process that will make the calculation populate the fields HeightClass (yellow icon), HeightGroup (yellow icon), and HeightDescription (yellow icon). Would appreciate your advice on my next steps.
Thanks again, Mike, for your assistance so far.
Since I can't see your screen, telling me the icon is yellow isn't particularly helpful.
In which table are HeightClass and HeightGroup? They should be in tblHeight. Just show the fields from that table on the current layout (instead of trying to copy the data across).
Thanks Mike for your guidance. I have finally got it working. I appreciated your help.