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