Take a look at my copy of your file as Shots&Assets1
Is this what you mean? You can make point 6 work just by adding a portal to your shot centric view. This will show the list of assets A, B etc.
But, I think that the method you are using is OK to work in one direction only. If you wish to select records from either view, then you will need to create a many-to many relationship by adding a join table, as you can see in Shots&Assets2.
Thanks for the reply.
Those setups are close to what I came up with minus the join table... still trying to wrap my brain around the relationship graph when it goes beyond simple matched fields.
I've created a quick file to illustrate what would be an ideal setup as far as functionality. (pay no mind to the ui of course)
So this setup works for each side, but the records don't update each other.
I'm sure I could write a script or layout to gather the information from one record and display it in another. But I would really like the functionality of entering data from either side of the relationship.