I have multiple tables with different field names. All table are linked to a table named "RESEARCH_REPORTS". I need to search and return all fields that contain let's say the string "parent".
Union queries seem limited to just two tables.
Really stuck on this. Any suggestions?
Not opposed to using VBA.