I have two tables in an outer join relationship with cascading up and down and a third that is a lookup table not linked to anything. This 3rd table, the lookup table, provides the data to a value in one of the linked tables via the lookup tab, as a combo box.
I made a query (QRY_MAIN) off of...