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

Question

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.&nbsp;How I can connected tables?&nbsp;For example,&nbsp;if in table 2 , ID #1 changed its status&nbsp;to completed in the field status, then QB will automatically&nbsp;update&nbsp;status in table 1 with id #1.In excel I used Vlookup formula for that...

johnrogers3 · Answer

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?

ilyailya · Answer

Sound good, how I can make such a lookup?

johnrogers3 · Answer

Sorry for late response, when making a field the very last field type should be a lookup field.

Careful changing field types because it will delete all stored data connected to the previous field data type. I would recommend creating an entirely new field just for testing, make it a lookup field.

Another way to do this,

Table 1: Field 1 = testField //this is a text field
Table 2: Field 2 = testField2 //this is the lookup field which is a formula text

now in the formula text you just put in [testField]

this will import whatever is in testField and display it in testField2

ilyailya · Answer

thank you.

Forum Discussion

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

Related Content

PDF Document Generator, automatically attached to a record

Generate a number

Create A New Record In the Parent Table from the Child Record's Information

Checking for missing information in a form

Document creation will be generally available on October 31