Skip to main content
Question

how to get information from the dependent table into general table, similar Excel Vlookup

  • September 21, 2018
  • 0 replies
  • 43 views
Hello,

I have 2 tables in my App, 1st is the general one, which should contain all statuses from the second table.

In both that tables I have equal ID numbers as a key. 

How I can connected tables?
 For example, if in table 2 , ID #1 changed its status to completed in the field status, then QB will automatically update status in table 1 with id #1.

In excel I used Vlookup formula for that...
    This topic has been closed for replies.

    Instead of changing it by automation, why not change the field in one of the tables to a lookup field to match the status of the other. So at all times the statuses will match? Would this not fix your problem?
    Terms & ConditionsAccessibility statement