ANY(SELECT) function

[dpotoole1971]

I have two tables. Table 1 is "JOBS". Table 2 is "WEATHER".

The WEATHER table has columns for DATE, CITY and HIGH TEMP.

The JOBS table has columns for JOB NO., DATE, CITY AND HIGH TEMP.

I want to use the data in the High Temp column in the WEATHER table to populate the High Temp column in the JOBS table.

This is the formula I have tried:

ANY(
SELECT(
Weather[High Temp],
AND(
([Date] = [_ThisRow].[Date]),
([City] = [_ThisRow].[City]),FALSE)
)
)

I have this formula in the "initial value" field. When it is in the "Initial Value" field nothing happens.

When the forumla is in the App Formula field the field disappears completely from my Form view and any other view.

Can anyone advise what I am doing wrong?

[WillowMobileSys]

The FALSE is inside of the AND() making it so nothing is matched with the filter.  The expression should probably be:

ANY(
    SELECT(Weather[High Temp],
           AND(
               [Date] = [_ThisRow].[Date],
               [City] = [_ThisRow].[City]
           )
    )
)

I hope this helps! 

[dpotoole1971]

Thanks very much. That solved the problem.