Using Lookups

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a lookup scenario that gives me the form & paper color listed below
All ENG 100-699 courses (except ENG 265 & ENG 266) Use form 1 & Pink paper

ENG 265 & ENG 266 use form 4 & Pink paper

All WR 100-699 courses (except 320 & 321) use form 2 & yellow paper
WR 320 & 321 use form 3 & yellow paper

All FLR 100-699 use form 1 & Lavender paper.

Is there anyway to do this without having to enter 600 courses for English, 600 courses for Writing & 600 Courses for Folklore?

SUBJ Course Form Color

ENG <>265, 266 1 Pink
ENG 265, 266 4 Pink
WR <> 320,321 2 Yellow
WR 320, 321 3 Yellow
FLR 100-699 1 Lavendar
 
I posted a similar question last night & it told me the post failed - so I rewrote it this morning but now all of a sudden my question that supposedly failed showed up with an answer. So NEVERMIND!!! And thanks for the response to the "failed" posting.
 
Back
Top