Problem with Relationship between 2 tables

Discussion in 'Software' started by pallavimahajan, Jan 31, 2005.

  1. pallavimahajan

    pallavimahajan Private E-2

    Hi everyone,
    > I have this weird problem of MS Access.
    >
    > I have started working in a team, where 2 tables have
    > been defined, Basic & LRS.
    > The primary key of Basic i.e. Segment ID is the
    > foreign key of LRS.
    > Now when those 2 tables were designed, some1
    > overlooked this thing.
    > I want this to happen, but i cannot enforce
    > referential integrity becuase some the data in the
    > table does not satisfy the relationship.
    > As a result i defined a new database with the same 2
    > tables and also defined the realtionships between the
    > two. Now the data from Basic is successfully copied,
    > but from LRS it is not. It gives me errors even when
    > the relationship is satisfied.
    > Can ne1 help me in this.
    > Thanks
    > Pallavi Mahajan
    >
     

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds