SQL SERVER 7.0

Im having a problem determining the underlying tables from a view using Sql Statements.

Create 2 tables having Employee_no in both tables.
Create a view linking these two tables on the Employee_no columns.
Select only the Employee_no column from Table 2 as output in the view.

Here is where my problem starts.
Using Sysdepends, SysColumns, SP_help , SP_depends - I am unable to determine what table the Employee_no output field is coming from.

Syscolumns showing the underlying tables and the colid from the underlying tables would solve my problem.

PLEASE HELP!
I need this information to pass to the front end to build the cursor properties of the result set(s).