AnsweredAssumed Answered

Retrieving data

Question asked by AdamRoberts on May 30, 2014
Latest reply on May 30, 2014 by philmodjunk


Retrieving data


     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