trying to figure out the lookup rule for the following fields.  i have campus type (high school or middle school), campus name, based off of campus type and campus name sports should populate, and based off the sport you select head coach name, email, and laserfiche account should populate.  so far i have gotten the majority to work but when selecting "sport" all coaches for that sport populate.  is there a way to separate that and only have it populate to their designated sport?  in the database i created the columns that are included are type (high school or middle school), campus name, sport, head coach, head coach email, and head coach laserfiche account.  all sports associated with the campus and campus type are in separate rows.  i have uploaded the current lookup rules i currently have in place in the form.