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 the two tables that are linked and a form (FRM_MAIN) based off of the query, but now the combo box that gets its values from the lookup table will not allow me to select a value in the combo box, it lets me click on it, but it doesn't save it to nor display what I selected, just goes right back to blank, what am I doing wrong?
I made a query (QRY_MAIN) off of the two tables that are linked and a form (FRM_MAIN) based off of the query, but now the combo box that gets its values from the lookup table will not allow me to select a value in the combo box, it lets me click on it, but it doesn't save it to nor display what I selected, just goes right back to blank, what am I doing wrong?
