# Sorting or Ordering by a Foreign Key

**URL:** <https://forum.bubble.io/t/sorting-or-ordering-by-a-foreign-key/32495>\
**Category:** Need help\
**Created:** [July 1, 2018, 1:59am UTC](https://forum.bubble.io/t/sorting-or-ordering-by-a-foreign-key/32495 "2018-07-01T01:59:36Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![akerezy](https://avatars.discourse-cdn.com/v4/letter/a/7ba0ec/32.png) [@akerezy](https://forum.bubble.io/u/akerezy)\
**Post date:** [July 2, 2018, 10:31am UTC](https://forum.bubble.io/t/sorting-or-ordering-by-a-foreign-key/32495/5 "2018-07-02T10:31:06Z")

</div>

**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).

---

_[View the full topic](https://forum.bubble.io/t/sorting-or-ordering-by-a-foreign-key/32495)._