Hello everyone
I have two simple tables which are in a n-to-m relationship (see the attached DB). I need to create a form for the cross-ref table, which shows two fields (norm and destination) of the table Norm, and the parameter description (and unit of measure UM) from table Parameter. These two tables contain master data. The user should be able to select one record from the first table and one from the second to join them in the cross-ref table, and then add the threshold. Consider that Norm and Parameter may have hundreds of records, and that once the relationships are created, they will rarely be modified (if ever); some may be added, but Threshold contains master data, essentially. The current solution, frmThreshold, does not look so good, from a functional perspective. The user should be able to consolidate the inputs. Any suggestions? Thanks a lot.