How to pull data from table 1 to table 2 if it matches a condition?
Complete newbie here so go easy. Table_A contains 2 fields: 'Name' and 'Status' (Active or Expired)How can I automatically pull all 'Names' with only status 'Active' into a field in Table_B?I want it so that any changes made to the 'Status' in Table_...