lookup rules are not matching accordingly to database.  for example, when campus/dept matches data source column TYPE, fill campus/dept name with data source value NAME.  this worked before in 9.1 where i would select TYPE and my 4 options of the different divisions in our school district would populate (campus, curriculum, operations, and secondary) then by selecting 1 of the TYPES, NAME would populate for example:  if CAMPUS was selected a list of my campuses would show up then another look up rule would be created when campus name is populated, admin name is populated as well.  i can't do that in 9.2.  any ideas??????