[pilot-db-list] Sort selecting

[Jason S. <ja...@NJ...>]

I have two db's on with a list of institution and the state they are in and
another db for data entry.
I would like to be able to have the following lay out:
Field1:State ----- links to inst. Db state column
Field2:Institution ----- list is generated from the state in field1 to limit
the amount to scroll through.
		so if state=pa then only pa institutions will show up when I
pull this list for institutions.

Right now I have field1 link and filed2 linked to institutions and it brings
up the whole list and fills in both fields when I select one item, which is
fine for a small list but this list is big and it takes a while to scroll
through it.
I'm new to this type of db so please explain well.

TIA

Jason