Re: A question about views in sql server

Tech-Archive recommends: Speed Up your PC by fixing your registry

Actually I tried to do that without success.
Could you please tell me how?

Here is what I did:
I set a relationship between two tables using the database diagram, which
should be a one-to-one relationship and is a one-to-many relationship, and
made a view which would combine the fields of both table. When I try to edit
the records, the status bar says recordset is not updatable... and also new
records cannot be added to this view. I have the primary key set in one
table, and the foreign key set in the other table. I don't know how to make
a one-to-one relationship in SQL server, and make an updatable view.

Please help me.

Shafiee.

"James Goodman" <jamesATnorton-associates.co.ukREMOVE> wrote in message
news:een136gYFHA.2420@xxxxxxxxxxxxxxxxxxxxxxx
> In a word, yes!
>
> As long as you have PK/FK fields on both tables (so that both tables are
> updateable individually), then this shouldnt be a problem.
>
> --
> Cheers,
>
> James Goodman
> "Mohamed Shafiee" <shafee_mohamed@xxxxxxxxxxx> wrote in message
> news:OKx3c1gYFHA.3712@xxxxxxxxxxxxxxxxxxxxxxx
>> Hi,
>>
>> I just want to find out if it is possible to create views in SQL server
>> which can be updated in an adp project. Can we create a one-to-one
>> relationship between two tables in SQL server using database diagram, and
>> achieve an updateable view? How can we do this in MSAccess adp projects?
>>
>> Shafiee.
>>
>
>


.

Relevant Pages

  • Re: A question about views in sql server
    ... and the foreign key set in the other table. ... >>> I just want to find out if it is possible to create views in SQL server ... >>> relationship between two tables in SQL server using database diagram, ... >>> Shafiee. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Write Conflict
    ... I have to download the latest service pack for SQL server. ... > Shafiee. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: A question about views in sql server
    ... As long as you have PK/FK fields on both tables (so that both tables are ... then this shouldnt be a problem. ... > I just want to find out if it is possible to create views in SQL server ... > which can be updated in an adp project. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Write Conflict
    ... the same view cannot be edited in enterprise manager. ... The bug exists in both access and SQL server i guess. ... > Hello shafiee, ...
    (microsoft.public.access.adp.sqlserver)
  • A question about views in sql server
    ... I just want to find out if it is possible to create views in SQL server ... which can be updated in an adp project. ... Shafiee. ... Prev by Date: ...
    (microsoft.public.access.adp.sqlserver)