SQL DB Form, second added table to data source structure wont repeat - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

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

Last post 05-26-2015 07:04 AM by Jnellson. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 05-22-2015 03:18 PM

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

    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    

  • 05-26-2015 07:04 AM In reply to

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

     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    

      

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.