I have 2 lookup fields Program Name PA and Division Name DN
Program names are
PA
PB
PC
Under program name PA comes division
DN1
DN2
DN3
Under Program name PB comes division
DN4
DN5
DN6
when I select PA and when I click lookup Division Name it should list DN1, DN2, DN3
when I select PB and when I click lookup Division Name it should list DN4, DN4, DN5
PLEASE LET ME KNOW HOW TO DO THIS......