By "normal" I mean two things. First and foremost, I mean "normalized". Take a look at this file...it's your database but normalized. Go to the Tools menu and pick Relationships, then drag the tables around to make it look like the bitmap I included in the archive. (I have Access 2000, which won't retain Relationship diagrams when converting to 97.) The only thing that isn't normalized is the pricing based on amount type. Which brings me to my second meaning of "normal".
The price based on quantity type is not normally found in your average business application. While it certainly could be, and would provide an interesting exercise in database design and normalization, it is more difficult to do properly than is worth the effort for a sample application.
The database I've included is normalized except for the quantity-based pricing issue. If you understand how and why I set up the tables this way, and can connect your apps into the new structures, that would be a big step forward for both your database abilities and your sample app.
Reply With Quote