I am not sure you can do that with a view, but you can create a table that reference the primary keys of the other two tables and set the primary key for this table to be an Identity - which will get you the autonumber feature.
id int PK IDENTITY
table1_id int FK
table2_id int FK
You set a primary key as IDENTITY in the Enterprise Manager in the design view for the table.