InfoPath inventory control form

[dickohead]

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.

 

[Mr. B]

In short, Access (any version) will allow you to create what you are looking for.

Your structure seems fairly correct but it sounds like the tool you are using to present your data is not allowing for the view you need. Access will do that.

However, my question is; are you needing to have this data updated over the web?

If so, you should consider looking at Visual Web Developer 2008. This is the "free" web development product from Microsoft.