Really struggling with this for quite sometime so would truly appreciate for any possible help.
I am trying to Append records from 2 tables (OppDetailT and PartsT) to 1 table (ItemsT) using an Append Query which is appending 0 records. Records that I want to append from 'OppDetailsT' table to 'ItemsT' table are 'Quantity' and 'UnitCost', and the record I am trying to append from 'PartsT' table to 'ItemsT' table is 'PartID'. I have some sample data in my db that I am trying to append. Later on, my objective is to use ItemsT table as a subform in a QuoteEntryForm (MainForm) where these records will be appended based on a combobox selection. This subform will display item details (PartNo, PartDesc, Qty, Unitcost) that will be recorded for a particular QuoteID. I am not worrying much about the form/subform setup yet as my Append Query itself has some issue.
As seen in attached image, 'ItemsT' table has one-to-many relationship with multiple tables, which are OppDetailT, PartsT, and QuoteHeaderT(for QuoteID) tables. All the FKs are a required 'yes' field in my ItemsT table. Not sure what other details I should provide here so I could post my db if needed.
I have researched almost every possible video/forum available online regarding this, but couldn't be successful. I might be missing something really basic or my approach could be incorrect, but have really given it too much time so seeking help here. Thanks in advance for any possible help.