Please someone help me! I might be the biggest idiot in the world -
but I can not figure this out to save my life.
I have a table - with an autogenerated primary key, and I want each
record in this table to link to multiple records in another table, but
I can not figure out how to copy the data from the first table
automatically into the second table
Here is an example -
InvoiceID (This is the Primary Key)
LineID (PK for 2nd tbl)
InvoiceID (FK from Tbl1)
Each Line Item needs to be related back to a specific invoiceID - so
how do I get the InvoiceID to automatically insert itself into tbl2?
Any Help is greatly appreciated