I can see that an asset can have multiple policies, but can a policy cover multiple assets?
If so, that's a many to many relationship:
Asset::__pkAssetId = Asset_Policy::_fkAssetId
Policies::__pkPolicyID = Asset_Policy::_fkPolicyID
You can then place a portal to Asset_Policy on an Asset layout to see all Policies that cover that asset. If needed, additional fields in Asset_policy can document details pertinent to a specific policiy's coverage of a specific asset. Put a portal to Asset_Policy on the Policies layout and it will list all assets covered by that policy.
For an explanation of the notation that I used, see the first post of this thread: Common Forum Relationship and Field Notations Explained
Here's a demo file on many to many relationships that you may find helpful: https://www.dropbox.com/s/oyir7cs0yxmbn6i/ManyToManywDemoWExtras.fp7
Yes perfect, it's a many to many which is why I was stumped .... I knew it was a matter of time till you cleared that road block for me. Thanks Phil!!!!!