Query will not allow me to add new records

[gant_g]

Hello, I created the query below to add new records to a some joined tables
in a database. I ame not that familiar with access sql.

SELECT T100_TaxCredit_Applications.*, T120_SeparateApplicants.[FK$PhaseID],
T120_SeparateApplicants.ApplicantName,
T120_SeparateApplicants.ApplicantSignatory, T120_SeparateApplicants.Title,
T120_SeparateApplicants.Company, T120_SeparateApplicants.Address,
T120_SeparateApplicants.City, T120_SeparateApplicants.State,
T120_SeparateApplicants.County, T120_SeparateApplicants.Zip,
T120_SeparateApplicants.AreaCode, T120_SeparateApplicants.Phone,
T120_SeparateApplicants.TaxpayerID_Number,
T120_SeparateApplicants.FYPercentContributed,
T120_SeparateApplicants.Actual_INDIVCredit,
T120_SeparateApplicants.AllYears_PercentContributed,
T120_SeparateApplicants.Actual_INDIVAddtl, T_CPA.*, T_TaxCreditType.*,
T_TaxCredit_Additional.FYHealthCareCredit,
T_TaxCredit_Additional.FYAffordableHousingCredit,
T_TaxCredit_Additional.FYSolidWasteCredit,
T001_FiscalYears.TaxRehabilitationCreditPercentage,
T001_FiscalYears.FY_HealthCareBonusPercentage,
T001_FiscalYears.FY_SiteRehabilitationCompCreditPercentage,
T001_FiscalYears.FY_AffordableHousingBonusPercentage,
T001_FiscalYears.FY_SolidWasteCreditPercentage, T_HealthCare_Affidavit.*,
T001_FiscalYears.FY_HealthCareBonusPercentage,
T001_FiscalYears.FY_AffordableHousingBonusPercentage,
T001_FiscalYears.FY_SolidWasteCreditPercentage,
T_TaxCredit_Additional.FYSolidWasteCredit,
T_TaxCredit_Additional.FYAffordableHousingCredit,
T_TaxCredit_Additional.FYHealthCareCredit,
T_TaxCredit_Additional.FY_ActualSolidWasteCredit,
T_TaxCredit_Additional.FY_ActualAffordableHousingCredit,
T_TaxCredit_Additional.FY_ActualHealthCareCredit
FROM (((((T001_FiscalYears RIGHT JOIN T100_TaxCredit_Applications ON
T001_FiscalYears.[PK$FYID] = T100_TaxCredit_Applications.[FK$FiscalYearID])
RIGHT JOIN T120_SeparateApplicants ON
T100_TaxCredit_Applications.[PK$ApplicationID] =
T120_SeparateApplicants.[FK$ApplicationID]) LEFT JOIN T_TaxCreditType ON
T100_TaxCredit_Applications.[PK$ApplicationID] =
T_TaxCreditType.[FK$ApplicationID]) LEFT JOIN T_TaxCredit_Additional ON
T_TaxCreditType.[FK$ApplicationID] =
T_TaxCredit_Additional.[FK$ApplicationID]) LEFT JOIN T_CPA ON
T100_TaxCredit_Applications.[PK$ApplicationID] = T_CPA.[FK$ApplicationID])
LEFT JOIN T_HealthCare_Affidavit ON
T100_TaxCredit_Applications.[PK$ApplicationID] =
T_HealthCare_Affidavit.[FK$ApplicationID];

 

[gant_g]

You can close this. I figured it out, it had something to do with my
relationships.