1 of 1 people found this helpful
Sometimes I feel like I'm some sort of weird geek relationships counselor, but here goes: "you have relationship trouble."
EventID is what you would normally use to identify a specific record in your Events table--a table not visible in above relationships graph. If you going to link a venue table to another table, it would normally be by a table named VenueID, not Event ID:
Events Detailed::VenueID = ctVenue::VenueID
In similar manner, linking a contact to a record in another table should only use one field: Contact ID. So in your case, the relationship between ctVenue and Contacts 2 should be:
ctVenue::Contact ID Match = Contacts 2::Contact ID Matchi... (Can't see the full field name in your screen shot.)
Thanks after 29 years of marriage who knew I had relationship issues
Going to have a good look at this on Monday and thanks for the suggestions.