I am missing something really simple as I have been stuck on this for over an hour, help would be appreciated
I want to populate a field call 'Number' in table 1 from a field in a row in Table 2 called "sales".
In table 1 and Table 2 I have a Fields named "Week" and "Day"
Therefore when I add the Week and Day in Table 1, I want it to go to table 2 and find the "sales" from the row with that week and day, and then return that number to the "Number" field in table 1
I have been trying to use an EQL quire