How to link multiple table in a single view page

Hi all,
i have a er structure like:
----table one----

field a key

field b
----table two----

field b key

field c

field d
----table three----

field a referencing one.a

field b referencing two.b

(a,b ) key
how can i show in a single "view page", selecting one.a row in table one, through a drop down menu listing three.b coupled with three.a where three.a = one.a, the list of two.c,two.d fields related with (three.a,three.b )?
thank you very much.
franco