locked
Dynamic Data Foreign Key Column empty data RRS feed

  • Question

  • User1643454553 posted

    I have two tables that are related via a foreign key.

     All the data is in the database and displays correctly using a sql query.

     When I run my dynamic data project the table that linked via the foreign key the, foreign key column stops showing data half way through.

    Also the filter dropdown also stops showing data half way through as below from view source:

            <option value="2863">2863</option>
            <option value="2864">2864</option>
            <option value="2865">2865</option>
            <option value="2866"></option>
            <option value="2867"></option>
            <option value="2868"></option>

     Any help would be appreciated.

     Thanks,

     Tom

    Monday, January 12, 2009 3:44 PM

All replies

  • User-330204900 posted

    Can you repro this using say Northwind? If not can you give the schema of the related table so the issues can be recreated. [:D]

    Monday, January 12, 2009 4:27 PM
  • User1643454553 posted

    the schema is


    TABLE: student

    id | firstname | middlename | lastname |

    TABLE: class

    id | studentid (FK from student table) | title | credits 

     there are around 5500 students

     thanks Tom B

     

    Monday, January 12, 2009 4:37 PM
  • User-1005219520 posted

    Do you get this problem from the wizard generated code (ie, you haven't made any modifications)? If the problem occurs on unmodified code, would it be possible to send me the DB so I can reproduce/debug the problem?  (you can do an update all to change the names, etc )

    Monday, January 12, 2009 4:57 PM