Hi All,
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?

What function does the TblIntermediate serve? If you insert into tblIntermediate, you can create a trigger/stored procedure that will insert into Systems or Printers. dependig on the "type" if it is defined.

I figured it out.