Skip to main content
Question

Compare fields in two tables and create a result in a different field

  • June 26, 2019
  • 0 replies
  • 69 views
I have two tables where one is incoming Requests and the other is a list of items that require Special Handling.  The key field (Article ID) is the same in both of them.

I want to have the article id in the Incoming Requests table compared to the Special Handling table and if it's there, populate a text field in Incoming Requests.  Can this be done?
      This topic has been closed for replies.

      Can you tell me if the Key field (in gold on the field list) for the Special handling table is the field 

      [Article ID]

      If it is, then you can make a relationship where One Special Handing has many Incoming Requests, and let the system create a field for you called [Related Special Handling].

      Rename that to be called [Article ID mirror] and change the field type to be formula (either text or numeric according to the field type of Article ID), and then set the formula just to be

      [Article ID]

      The lookup the Special Handing words from the special handling table down to the incoming requests.  The reason for the mirror field is that when you enter an Incoming request, I'm guessing that not all items have an entry in the Special Items table, so I don't want to force you to choose an item # off the Special handling table for the Incoming requests that do not have an entry in that table.






      • TinaDilts
      • Author
      • Quickbase Alumni
      • July 12, 2019
      I thought I had that part working.  The mirrored field is showing exactly what is in the Incoming Requests [Article id] field whether there is a corresponding record in Special Handling or not.


      Terms & ConditionsAccessibility statement