I'm not sure I follow, so please bear with me and clarify if I've totally misunderstood.
Could you not directly relate POL_Policy to pol_insurer_PREMIUM and pol_insurer_POLICYno? Both relationships would be where _fk_insurerID = __ID_insurer. (Well, I see one has a second underscore, by I think you see what I mean?)
You could then add start date to whichever relationship, and I'm thinking the challenge is that that's in the POL table? (I actually can't see that field anywhere in the image.)
Please let me know if we're on the right track, here.
Thanks for taking the time tho look.
History I set this up 10 years ago without the need for the insurer table.
When a new record is created in the policy table the first thing that we need to do is select an insurer.Eg Lumley
Thanks for taking the time tho look.(Previous email sent by accident).
I set this up 10 years ago without the need for the insurer table. I now need to include this table as there are more than one insurer involved. each Insurer has its own Unique policy number for each month. and premium band for values from $5,000 in steps to 1,00 to $30,000.
I have added an “_” to the relevant fields to make them visible in the POL_POLICY table.
When a new record is created in the policy table, we need to select an insurer.from the list. Each insurer will have a unique number for each month which we will add a serial number to form the (BrokersPolNo_c). The sum Insured relates to the value of the item in POL_POLICY When this is selected then we can grab a value for Premium & Payable from the Pol_insurer_PREMIUM .
I have included an updated TOG.
Hopefully this makes it easier to understand. I do not have a lot of experience in this area and I seem to have got myself a little confused.