MS Access-like relationship views in MS SQL

how can I view and modify related db records in Enterprise Manager?

[broniusm]

How can I reproduce Microsoft Access related table views in Microsoft SQL Server?

ex: two tables, Report and ReportParams

I'd like to have a view that joins the two tables on:
Report.ReportId
ReportParams.ReportId

..which shows only a given report's parameters at a time.

In Access, you do this in a simple-to-use double-table where the parent table's record shows and the corresponding child table's records show immediately below. All data is modifiable, and it's pretty slick.

ideas?

[aspdaddy]

Is a view not updateable in enterprise manager?
Something like this.

Select ReportParams.*,Report.*
From Report INNER JOIN ReportParams
On Report.ReportId =ReportParams.ReportId 

[broniusm]

aspdaddy- thanks for the reply: you got really close to (but better than) what I'm doing now.

So yes, I will do that if i have to-- what I'm really looking to do, however, is not display any repeated info (for instance in your ex., all data from the Report table), but only one line of one table, and one "sub" table just like relationships in Access. Is there a way to do that?