I have two tables, a problem table and a problem history table. As you can expect, a problem can have many histories associated with it.

CREATE TABLE [dbo].[Problem](
[Last_Update] [datetime] NULL,
[Problem_Id] [int] NOT NULL,
[Incident_Count] [int] NULL

)

ALTER TABLE [dbo].[Problem] ADD  CONSTRAINT [PK_Problem] PRIMARY KEY CLUSTERED 

( [Problem_Id] ASC )

CREATE TABLE [dbo].[Problem_History](
[Last_Update] [datetime] NULL,
[Problem_Id] [int] NOT NULL,
[Severity_Chg_Flag] [char](1) NULL

) ALTER TABLE [dbo].[Problem_History] ADD [Create_DateTime] [datetime] NOT NULL

ALTER TABLE [dbo].[Problem_History]  WITH CHECK ADD  CONSTRAINT [FK_Problem_History_Problem] FOREIGN KEY([Problem_Id])

REFERENCES [dbo].[Problem] ([Problem_Id])

The problem is when I drag this into an Entity Model, the associations are not included. Any ideas? I would like to point out that the problem history table has no separate key of its own, it shares the problem id