LOOKUP() Values from different table

[Hussein_Osseily]

Good day Everyone, 

In my application , there are two tables: 
Table 1:
Master sheet that has the following columns:
Order Number / Contact Name / Order Time / Transport Company

Table 2:

Damage Report that has the following Columns:
Order Number / Contact Name / Order Time / Transport Company

I am following this expression , as column formula but for some reasons i am getting no results
in the contact name where i want the value to be automatically filled i have used the following expression:

LOOKUP("Order Number", "Master Sheet", "Order Number", "Contact Name")

in the Order Time column: 

LOOKUP("Order Number", "Master Sheet", "Order Number", "Order Time")

and so on...

The result that I want to achieve is whenever I write down the Order Number in the form (Damage Report View) the rest of the information to be filled automatically according to the lookup expression i have written in every column.

It would be helpful to point what i am missing here

thanks

[jyothis_m · Accepted solution]

Try 

LOOKUP([_ThisRow].[Order Number], "Master Sheet", "Order Number", "Contact Name")

LOOKUP([_ThisRow].[Order Number], "Master Sheet", "Order Number", "Order Time")

I think better option is to make Column ORDER NO. of Table 2 as Type REF with Reference to Table 1

So that you can directly get the Contact Name , Order Time etc using deference expressions

[Order Number].[Contact Name]

[Order Number].[Order Time]

[jyothis_m · Accepted solution]

Try 

LOOKUP([_ThisRow].[Order Number], "Master Sheet", "Order Number", "Contact Name")

LOOKUP([_ThisRow].[Order Number], "Master Sheet", "Order Number", "Order Time")

I think better option is to make Column ORDER NO. of Table 2 as Type REF with Reference to Table 1

So that you can directly get the Contact Name , Order Time etc using deference expressions

[Order Number].[Contact Name]

[Order Number].[Order Time]

[Hussein_Osseily]

Thanks man, i followed this method and its working great 

LOOKUP([_ThisRow].[Order Number], "Master Sheet", "Order Number", "Contact Name")

LOOKUP([_ThisRow].[Order Number], "Master Sheet", "Order Number", "Order Time")

[Swoopy]

Have you put the expressions in INTITIAL VALUE?

Put here to display on forms.

[Swoopy · Accepted solution]

Also the

LOOKUP("Order Number", ".........

means you tell AppSheet to look up the text "Order Number", not the column's content. You need to use [_THISROW].[Order Number].

[Hussein_Osseily]

Thanks for your response, it worked !