The power is in the Master child links, which links the Auction to the items and bidders and the Items to the bidders and winners, which are actually the same thing just presented differently.
There is also the power of the Queries that supply the forms, they can present the data in different orders, so the Winners form on it's own tab just presents them as they happened, but the one on the Item Dis form presents them with the last one at the top.
There is some fairly simple VBA to update the forms by requerying them etc.
It doesn't at the moment check if the Auction Item quantity is greater than the Item Stock Quantity but it can.
It could also control the Item stock level when you set the auction level.
Once the data is in there and you have the Auction you can then run analysis on what sells best and at the most profit, Who is consistently the best bidder etc.
How many more products could have been sold if you had more stock.
Hey OBP, thank you for taking the time to show me and explain access relationships, subforms and the best way to run access. I am going to work on learning more about relationships between tables because I know I lac in that area.
KDC, you are welcome, it is my retirement hobby.
A good old Access book would help a lot, it won't have all the new fangled stuff that has been added to Access over the years, but it will have the Basics of Relational Database, Relationships, query, Form and Report Design.
Or you can ask me on here or by email if you need clarification on something.
I have attached a summary that I wrote many many years ago that might provide you with a starting point (or not).