Post reply

sharing entities

  • January 20, 2004 at 5:24 am

    #83366

    I have two tables, tableA and tableB.

    ent1 is the primary key in tableA and also exists in tableB

    Is there anyway the formatting of ent1 can be inherited directly by its instance in tableB?

     

    Cheers!


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

  • January 20, 2004 at 5:26 am

    #490783

    .....basically I want to format ent1 in tableA and need it to have the same formatting in tableB. Is the addition of a foreign key constraint enough to do this?


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

  • January 20, 2004 at 5:42 am

    #490787

    Hi Andrew,

    what exactly do you mean by 'formatting' ?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • January 20, 2004 at 5:55 am

    #490788

    OK, basically making ent1 = ent2+ent2+ent4;

    etc etc......

    make sense?


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

  • January 20, 2004 at 6:02 am

    #490792

    not really

    can you help me with an example?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • January 20, 2004 at 6:20 am

    #490793

    not really got one to hand right now, im just thinkin out loud at the moment........


    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

Viewing 6 posts - 1 through 5 (of 5 total)

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