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

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

4’8” 91G

182 L

K

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.

RELATIONSHIP:

Heres my T.O. graph setup