Qrew LegendSure, this is no problem. You already have a master table of contacts which is perfect. You need to create a new table sometimes referred to in Quickbase as a Join table or a Many to Many join table for Event Contacts.
So create that table and initially don't add any fields to it. Then create a relationship where one event has many event contacts and be sure to pull down the look up field for the event name as you're very first look up field and it will become what is called the reference proxy for the event.
Then make a relationship where one contact has many event contacts and pull down the first look up field as the contact full name.
Then on the form for events, you will want to put an embedded report of those event contacts, showing the full name of the. And similarly it's possible on the contact record. Do you want to put an embedded report of events showing all the events that contact has ever been involved with.
Then you can also decide if you want to add any fields to the event contact, which are not look up fields from the contact or the event itself. For example, you may have a date field of the date of the contact.
