Solved: SQL DB Form, second added table to data source structure wont repeat

Jnellson — Tue, 26 May 2015 14:04:32 GMT

I screwed up the SQL. Table three should have looked like:

CREATE TABLE [MEDD].[dbo].[TBL_IMPLEMENTATIONS_LOG_TABLES](
    [TABLE_USED_ID] int IDENTITY(1,1) NOT NULL Primary Key,
    [CHANGE_NUMBER] int FOREIGN KEY REFERENCES [dbo].[TBL_IMPLEMENTATIONS_LOG]([CHANGE_NUMBER]),
    [SERVER_USED_ID] int FOREIGN KEY REFERENCES [dbo].[TBL_IMPLEMENTATIONS_LOG_SERVERS]([SERVER_USED_ID]),
    [TABLE_NAME] [nvarchar](255)
);
GO

SQL DB Form, second added table to data source structure wont repeat

Jnellson — Fri, 22 May 2015 22:18:43 GMT

I built a form for working with a few tables in SQL (table creation code below). When I built the form initially everything worked. I recently moved the DB to a new server and now the 3rd table in my data source structure will not repeat. When creating the connection table 1 was added first, then table 2 was related to table 1 on a single connected field. Then table 3 was related to the table 2 and there are two connected fields. This way there can be multiple table 3 entries for each table 2 and multiple table 2 entries for table 1.If I remove one of the two connected fields for the table 3 >table 2 relation then it repeats but i cannot submit the form due to a many to one relation. As I said before, this worked earlier this week with the exact same configuration, although I cannot repeat the success even with the old data set.

Please help, thank you!

Table 1
CREATE TABLE [MEDD].[dbo].[TBL_IMPLEMENTATIONS_LOG](
    [CHANGE_NUMBER] int IDENTITY(1,1) NOT NULL Primary Key,
    [REQUEST_TRACKER_ID] [nvarchar](6) NULL,
    [PRIORITY] [nvarchar](7) NULL,
    [HPSM_REQUESTOR] [nvarchar](30) NULL,
    [HPSM_APPROVING_MANGER] [nvarchar](30) NULL,
    [HPSM_APPROVING_VP] [nvarchar](30) NULL,
    [CHANGE_TYPE] [nvarchar](20) NULL,
    [SUB_SCRIPT] [nvarchar](20) NULL,
    [NAME_OF_SSIS_PACKAGE] [nvarchar](30) NULL,
    [NAME_OF_SQL_SCRIPT] [nvarchar](6) NULL,
    [LOCATION_OF_CHANGE_COMPONENTS] [nvarchar](255) NULL,
    [DESCRIPTION_OF_CHANGE] [nvarchar](255) NULL,
    [NAME_OF_DEVELOPER] [nvarchar](30) NULL,
    [DATE_DEPLOYED_TO_DEV] [date] NULL,
    [DATE_DEPLOYED_TO_TEST] [date] NULL,
    [DATE_DEPLOYED_TO_PROD] [date] NULL,
    [COMMENTS] [nvarchar](255) NULL
);
GO

Table 2
CREATE TABLE [MEDD].[dbo].[TBL_IMPLEMENTATIONS_LOG_SERVERS](
    [SERVER_USED_ID] int IDENTITY(1,1) NOT NULL Primary Key,
    [CHANGE_NUMBER] int FOREIGN KEY REFERENCES [dbo].[TBL_IMPLEMENTATIONS_LOG]([CHANGE_NUMBER]),
    [SERVER_NAME] [nvarchar](255)
);
GO

Table 3
CREATE TABLE [MEDD].[dbo].[TBL_IMPLEMENTATIONS_LOG_TABLES](
    [SERVER_USED_ID] int IDENTITY(1,1) NOT NULL Primary Key,
    [CHANGE_NUMBER] int FOREIGN KEY REFERENCES [dbo].[TBL_IMPLEMENTATIONS_LOG]([CHANGE_NUMBER]),
    [SERCER_USED_ID] int FOREIGN KEY REFERENCES [dbo].[TBL_IMPLEMENTATIONS_LOG_SERVERS]([SERVER_USED_ID]),
    [TABLE_NAME] [nvarchar](255)
);
GO

Data Connections

Solved: SQL DB Form, second added table to data source structure wont repeat

SQL DB Form, second added table to data source structure wont repeat