conversion

[Lee Ann]

I posted this a couple of days ago, and I not sure If
understand exactly what the reply meant. So, I thought I
would repost.

I have a couple of growthchart that I want to convert
into a program instead of looking it up on a piece of
paper.

One is weight based on age/gender other one is height
based on age/gender.

Depending on their Age and gender they should fall in a
certain weight and Height category- Which I have those
category values.

I am not sure how you combine Age and Gender to lookup or
convert inthe other values.

I have gender coded as 0 female and 1 males.

This is what the programmer suggest a couple of days

ago. I have been trying to link the table in a query but
not exactly sure how.

I'd suggest creating a Norms table with four fields -
gender, age,
height and weight. This table can then be linked in a
query to
retrieve the child's norms.


..

 

[SteveS]

Lee Anne,

John V. means make a table with five fields:

ID - autonumber
intGender - integer (0 or 1)
intAge - integer (1 to 20?)
intWeight - integer
inHeight - integer

Use this table (or a query based on this table) to do the
lookups.

I whipped up an example mdb. If you want, email me and I
will send it to you.

HTH

Steve

 

[Shirley]

You can insert the chart in the form. Add couple of combo
boxes or texts in the form as the criteria to view the
chart. You can set the childlink and masterlink in the
property window. When the content in combo boxes changes,
the chart changes accordingly.