I need some assistance in capturing data from the tables pol_insurer_PREMIUM and POLICYNO.
Policy table > Select the Insurer from drop down list to capture the foreign key in the Policy table.
This makes the relationship between the policy table and the selected insurer.
In selecting the sums insured in the policy table from a list I then need to set the premium and Payable that relates to the sums insured.
The start date selects the month which then should capture the Insurer Policy No from the table pol_insurer_POLICVYNO
Refer to attached TOG