Create a list of all of the values in a column

Question

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
------------------------------

markshnier__you · Answer

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 · Answer

The key field in A is Order Number and Record ID# is the key in B------------------------------Paul Peterson------------------------------

markshnier__you · Answer

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
------------------------------

paulpeterson1 · Answer

That's a great idea!&nbsp; and no need to filter, it will be used as part of a validation script and the relationship already exists.Thanks Mark!------------------------------Paul Peterson------------------------------

Forum Discussion

Create a list of all of the values in a column

4 Replies