Forum Discussion

PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
3 years ago

Create a list of all of the values in a column

Is it possible to create a list that has all of the unique values in a column in a different table?  For example, suppose Table A has an order number field and I want to see if the order number entered in Table B is in the orders in Table A.  What is the best way to do this and make sure the list updates with each new record in Table A?

------------------------------
Paul Peterson
------------------------------

4 Replies

  • Can you tell us what the key field is of each table?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • PaulPeterson1's avatar
      PaulPeterson1
      Qrew Assistant Captain
      The key field in A is Order Number and Record ID# is the key in B

      ------------------------------
      Paul Peterson
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        You can make a field in table A called [Order Exists?]  as a formula checkbox with a  formula of 

        true

        Then make a relationships where One table A has Many Table B's and for the reference field on the right use a formula field with the value of [order#] as the formula.  ie a mirror of the order#.

        Then in that relationship look up the field of [Order Exists?] 

        Then are you have to do is make a report filtered by where [Order Exists?] is unchecked.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------