Thanks for your honesty Nicolas.
So - even though the child “bid” has a column called “auction” (the parent) of data type auction, your suggestion is to have an additional column in the child bid table called “auction name” or “auction ID” - that is NOT a reference back to the parent, but it replicated data, so then the child can be sorted by that.
I think the application would be 1,000 times better with a relational back end rather than an OO back end. You would instantly have 100,000 users (all MS Access Users would LOVE this, and you could market to them as well).