how tie dropdown list gridview sharepoint 2007?

this should unequivocally really rudimentary thing, nonetheless reason only eluding me.

i wish sharepoint page have dump down list tied database lookup table.

when an vigilant comparison click button, i wish transform gridview also page.

i'm looking rudimentary - while presumption i'm sharepoint idiot. btw, i am controlling microsoft business sharepoint designer.

thanks,

edit:
my need indeed unequivocally simple. i wish filter law query controlling dump down list. used called master - fact relationship.

for example, unchanging information propagandize name, concentration name, enlarged concentration running. since there hundred applications per propagandize there 60+ schools, i wholly wish arrangement schools information during time.

so, i wish put dump down list during tip shade contains list schools. selected, gridview should updated simulate new schools information.

chris.