Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The attribute key cannot be found Expand / Collapse
Author
Message
Posted Friday, August 30, 2013 8:35 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 3:54 AM
Points: 279, Visits: 556
Warning 12 Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'dbo_Person', Column: 'UEmployeeID', Value: '41178736'. The attribute is 'U Employee ID'. 0 0

I understand that I am getting this error because this UEmployeeID is in one table and not the other

however this is a one to many relationship, and the primary key for the UEmployeeID field is on the Person table and this has a complete unique list of UEmplyeeIDs and on the Benefits table the UEmployeeID '41178736' does not appear but this is the many part of the relationship so it shouldn't need to? should it?

I hope you understand what I mean

thanks in advance
Post #1490187
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse