InfoPath simple inventory control - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

InfoPath simple inventory control

Last post 03-10-2010 10:27 PM by tim.dickinson. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 03-10-2010 10:27 PM

    InfoPath simple inventory control

    Hi all,

    I'm having trouble with something that should be very simple, so I'm obviously doing something wrong.

    I have the following Access database structure.

    # Location
    *LocationName - PK

    # LocationBookQuantity
    *LocationName - PK
    *BookID - PK
    *Quantity

    # Books
    *BookID - PK
    *BookName
    *Cost
    *BookGLCode

    The relationship between Location and LocationBookQuanitity (LBQ) is One to many - one location, many books.

    The relationship between Books and LocationBookQuanitity (LBQ) is One to many - one book, many locations.

    So... my dilemma is that InfoPath does not allow me to create a form from a data-source where many to one relationships exist, I assume this is because the data can be viewed from either the location end or the publication end (show me all the books for location x, or show me all the locations that have book x).

    How do I set up a very basic inventory control as specified above?

    All I want is to be able to group results by location, display the books per location and allow users to adjust it. It hardly seems fancy at all...

    I'm using InfoPath 2003 too, if 2007 will help me I may just weep a little.

     

    Cheers,

    Tim.

    UPDATE: This post was excellently laid out, yet apparently the forum doesn't like the enter key through Chrome very much and squashed my message into a blob... i pasted in Wordpad to try and fix it... apologies.

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