And here come the questions.....
Your tables are set up so that:
tblCompany has two fields--ID and Name
tblPlanTypes also two fields ID and Name
But then TblPlanName has four fields--ID, fkCompany, fkPlanType and the PlanName
Mine are not like that but should they be??
My tblCompany has the same two fields as yours
My tblPanType has THREE-- ID, fkCompany and the PlanTypeName
My tblPlanName has THREE--ID, fkPlanTypeID and the PlanName
I am guessing mine are wrong somehow--but they are currently working on a nifty form that let me choose the company, then add their plan types and the plan names (one main form two subforms) I did not create this form soooo if I break it I'm in trouble. I just spent two hours sorting out plan types from plan names. You have yours exactly as they should be and I straightened mine around finally.
So anyway----should I change my Plan name table to include all four fields like yours and put my plan type table down to two fields? What's the best approach for long term use? I am guess your third table acts a junction? Maybe?
Just when I thought I could get started on this, I am back to square one.