I am trying to link 2 tables names Assets and Tests to a table named Results. I need the links to both be left outer joins, but when I try this I get a message of "If tables are already linked then Join Type can't change." The links work if the joins are equal.
I need to be able to display data from the two tables on the left regardless of weather there is data in the right (results) table. The 2 links from the left tables (Assets, Tests) are linked to separate fields in the right (results) table.
Please let me know if more info is needed. Thanks in advance.