Hello, I have this rather tricky design which baffles me.
The structures relevant to this question are as follows:
policy_list: policyID, policyname, region
policy_details: pdetailsID, pID (linked to policyID), pnotes, pdate
In essence, for every policy introduced, there're several revisions...