Relationships and Related List question

[Dan Johnson1]

I've got two tables:

1> Person - this stores details of a person (e.g. name, address etc).

2> Venues - this stores details of a venue (e.g. address, purpose etc).

A person can be situation at multiple venues and a venue can have many people situated at it. So far it's a simple many-to-many relationship.... however there's a twist

When person 1 is at venue 1 they are charged at a particular fee

My first thought was to add a new table PersonVenue which stores a reference to the expert and a reference to the location and setup relationships for this. This seemed to work ok in that I could perform what I needed HOWEVER the problem came when I started to add related lists to the Person and Venues form. 

On the Person form I want the related list to show the addresses of the venues they are based at

On the Venues form I want the related list to show the names of the persons that are based there.

So my question is which is the right way to go?

There seemed to be many drawback of the many-to-many (e.g. I could create duplicate person and venue records) and I couldn't store things like fees.

The 'bridging' table (PersonVenue) worked best but the related list options hampered the UX (if there is a way to fix this then this would be my preferred method)

Thanks in advance

[Dan Johnson1]

thanks @Kalaiarasan Pushpanathan 

1 - You can create additional fields on m2m table and that should be able to take care of this.

> I can see this now thanks. 

2 - Since Venue will be a reference field on m2m table, they can create a new venue if the record does not exist from the same form by clicking 'New' button in reference pop up window.

> I don't want the user to be able to create new venues this way, this is why I want them to launch the m2m form from the related list, so they are forced to choose an existing venue. i.e. I want the related list's NEW | EDIT button to launch the PersonVenueM2M form:

[Kalaiarasan Pus]

If you want to hide the 'new' button on venue reference field, you can even do it. You can use 'sys_ref_list' view to hide the new button.

[Dan Johnson1]

I guess this would work if clicking New on either the Person form's related list or Venue form's related list would launch the m2m table. Is this possible?