Same material different p number

[The Big Bear]

Hi all

I have 4000 records of steel in a separate table . Each steel is assign a grade and p number. The problem is that some steel p number changes with the thickness of steel changes.

Example A36 steel is a p number 1 when the steel is less than or equal .750" in thickness

But becomes a p number 2 when over .750" in thickness.

User of the welding program enters the steel grade and the p number field lookup the p number.

everything is good when the steel grade has only one p number but when the steel has more than one p number because of thickness the program has a chance of not being accurate.

I tried a separate calculation field to populated the p number field when the p number changes but I must have something wrong because that did not work. Is there a way of looking up the correct p number when the steel p number changes because of thickness.

Thanks for your help in advance.

Lionel

Edited July 12, 2010 by Guest

[comment]

The best way to do this is to have a separate record for each p number, e.g.

Grade   Thickness   p

A36     0           1

A36     0.75        2

...

Then lookup the p number using a relationship based on:

Welding::Grade = Steel::Grade

AND

Welding::Thickness ≥ Steel::Thickness

(sort the related records from Steel by Thickness, descending)

Edited July 13, 2010 by Guest
Fixed a typo; descending, not ascending

[The Big Bear]

Thanks Michael