I'm using Access to create a database for my used book business. I buy books that have the same author/title at multiple purchase prices and sell at multiple sale prices. It may be a soft cover vs. hard cover price difference, or the price might just be a different based on the quality of appearance of two books purchased with the same author/title.
I need to be able to get the purchase price into the same table as the book titles but don't want to create multiple IDs for the same book title. Any ideas?