Forum Discussion

TinaDilts's avatar
TinaDilts
Qrew Member
6 years ago

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

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?
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    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's avatar
    TinaDilts
    Qrew Member
    6 years ago
    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.


    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      6 years ago
      Did you make a relationship between Incoming requests and Special handling?  Did you lookup the special handling Instructions field for the reason