1 Reply Latest reply on Jul 10, 2003 10:53 PM by vbfischer

    CMR Difficulty

    vbfischer

      Having some problems understanding CMR I guess. I've attached some code that will hopefully show what I'm doing in more detail.

      Here's the 5cent tour:

      Trying to establish a one to many relationship, unidirectional. From SYS_USER to USER_ROLE. I want to be able to get to the roles from the user table, but not from role to user.

      Everything deploys fine, but when I checkout the table, it has the following structure (SQL Server2000):

      CREATE TABLE [dbo].[USER_ROLE] (
      [recordid] [int] NOT NULL ,
      [userRoles] [varchar] (256) NULL,
      [username] [varchar] (256) NULL ,
      [SysUser_userRoles] [varchar] (256) NULL
      ) ON [PRIMARY]

      I am wanting it to be:
      CREATE TABLE [dbo].[USER_ROLE] (
      [recordid] [int] NOT NULL ,
      [userRoles] [varchar] (256) NULL,
      [username] [varchar] (256) NULL ,
      ) ON [PRIMARY]

      It seems to be adding that last column (SysUser_userRoles) because of my relationship tags.

      Please check my baggage attached and help me understand this..

      Thanks