Event to Contact Relationship

[sirmatt]

I am attempting to connect an event Database to a contacts database. I am familiar with filemaker but newer to creating databases. Here is my issue...

I need to have multiple contacts for one record. I would not like to use portals if possible. Currently I have tried

Event::EventId = Event_contacts::Event / Event_contacts::Contacts = Contact::ContactId

I then would like to select the contact from a pop-up menu if existing or create a new record if not existing within the events database.

I need to have multiple contacts for one event and multiple events for one contact. Any help would be great!

I am open to suggestions.

Thank you!

[efen]

I need to have multiple contacts for one event and multiple events for one contact.

This is a one to many relationship from both tables so you need a join table between them.

[bcooney]

Matt, have a look at this demo. It's an interface idea for populating a join table. Popup Selector

[sirmatt]

Thanks! This should help a lot!