Creating any number of relationships with records from one table to any number of records on another table
Hello, I currently have one table listing all our insurance policies and another table listing all our assets. What I would like to do is have the ability to create a relationship between any number of insurance policies to any number of assets. Most assets we currently own have multiple policies covering various functions they have therefore a single match field to associate one to the other will not suffice. I'd like to have the ability to go to my assets page and view of the associated policies in a list format through a portal.
I thought of creating a third table and using lookups but I want information to automatically update themselves should they ever get changed in the insurance policy table therefore I'm not sure how to proceed ...