I HAVE A QUESTION ABOUT INTERMEDIATE TABLES
I have 3 tables in my database: tblIntermediate, tblPrinters & tblSystems. tblIntermediate is my junction table and I have created 2 one-to-many relationships. 1 between tblPrinters & tblIntermediate and 1 between tblSystems & tblIntermediate. I have cascade update and cascade delete selected on both relationships. The trouble I am having is I want to be able to add data into tblPrinters and have it automatically go into tblIntermediate. Right now if I enter information into tblPrinters I have to add it to tblIntermediate as well, manually. Is it normal to have to update the same information twice when you have an intermediate table?