AnsweredAssumed Answered

Different Tables and Two Fields = One Answer?

Question asked by dj1up on Dec 23, 2016
Latest reply on Dec 24, 2016 by dj1up

Well my job has once again asked me to set up a rental program for our ski shop.  So my task at hand is to calculate and script out the process of how we set ski bindings using ISO blah blah blah......zzzzzzz.  I will save you from the rest of the details as they do not pertain to this question.

 

What i need to calculate is the skiers code (ranging from A-P), based off of two fields in my People Table and evaluate and extract the answer from my DINHeightWeight table. 

 

Tables:

     Fields:

People

     _id_DINwAndh_fk - Text Field

     Height - Drop down from DINHieightWeight

     Weight- Drop down from DINHieightWeight

     SkierCode - Edit Field

DINHeightWeight

     _ID_DINHW_PK - UUID

     Height - Text Field

     Weight - Text Field

     SkierCode - Text Field

DIN_Height_Weight_Code.jpg

How to:

  Start with the skiers height and weight on the chart.  Look at both columns and see which value you come to first on the chart starting at the top and working your way towards the bottom.                             

 

Height

Weight lbs.

Skier Code?

Skier   A

4’8”

91

G

Skier B

5’11”

182

L

Skier C

5’10”

208

K

                            

  

Height

Weight lbs.

Skier Code?

Skier A

  4’8” 91G

Skier B

5’11”

182 L

Skier C 

5’10”

215

K

Start with the skiers height and weight on the chart. 

Look at both columns and see which value you come to first on the chart starting at the top and working your way towards the bottom.

 

 

 

 

 

SCRIPT STEP:

 

DINHeight and Weight.png

RELATIONSHIP:

din RELATIOINSHIP TO.png

Heres my T.O. graph setup

 

 

Outcomes