Primary Key in SQL Server - InfoPath Dev
in

InfoPath Dev

Primary Key in SQL Server

Last post 10-18-2006 10:22 PM by Matt Faus. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 10-18-2006 01:30 PM

    • Michael71
    • Top 50 Contributor
      Male
    • Joined on 10-07-2006
    • Mclean, Virginia-USA
    • Posts 283

    Primary Key in SQL Server

    Reply Contact

    My Primary key...Report ID keeps on showing the same when I open up the form, should this key be incremented......Each time I save to the SQL database and open up with one number greater. What should I do to perform this?

    20
    19
    18
    17
    16
    15
    .....

  • 10-18-2006 02:09 PM In reply to

    • Michael71
    • Top 50 Contributor
      Male
    • Joined on 10-07-2006
    • Mclean, Virginia-USA
    • Posts 283

    Re: Primary Key in SQL Server

    Mark as Answer
    Reply Contact
    I figured this out Guys....I just went into Tools in InfoPath and Data Connections
    and click on sort desc...
    Also went in SQL Server to my primary key in design mode and changed that to desc as well.....Thanks...I'm learning

  • 10-18-2006 10:22 PM In reply to

    Re: Primary Key in SQL Server

    Mark as Answer
    Reply Contact
    Awesome! Sometimes you just need to take a step back and it will come to you.
    Matt Faus / Microsoft InfoPath MVP
    Qdabra® Software / Streamline data gathering to turn process into knowledge
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.