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
here's the attachment. Having difficulty attaching...