Post reply

using View in the relationship diagram

  • February 7, 2005 at 9:41 am

    #87391

    Hi

    I have a DB which use a few Views  because my customer dont allowe us full access to all of his table so instead he gives as Views.

    I need to inforce some relationship between my tables and the Views, any ideas ?

     

  • February 7, 2005 at 11:36 am

    #541002

    I have many solutions in mind but I need to know extacly what you are trying to accomplish. Can you provide us with the DDL of the views and what you are trying to do so we can provide an accurate solution?

  • February 25, 2005 at 10:56 am

    #544220

    TO make Thing simple let say my customer gives me a view of his employees table and i want to connect that view to my Rooms table using the field OfficeRommNum in the Employee view so if I change a room number in Room table it will update all the employees that are connected to the room.

    or that i wiil not be able to delete a room as long as there are employees connected to it.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply