troubleshooting Question

How do I link two databases?

Avatar of davidatlamont
davidatlamont asked on
FileMaker Pro
12 Comments1 Solution313 ViewsLast Modified:
I know this should be straightfoward but cannot figure this out.  Close, but not quite . . . Don't quite understand the "File References"/ "Relationships" functions.

I have two databases.
1.  Events (currently contains about 55 events with each record containing everything from audio/video needs to venues, etc.
2.  Contacts (a list of some 18,000 persons, many of which receive and attend events)

To this point these DB's have existed independent of each other with no tracking on who is invited/attends each event.

My goal is the following:
I want to be able to flag those in contact DB that are invited and/or attend an event.
Event DB users will not have any edit access to contact information, only view access; however they will be able to flag which events invited to/or attended.

I'm unclear whether "Event ID" & "Event Name" (Event DB) fields should be linked to contact DB and allow Event DB users access to these fields (from Event DB) or whether 'Contacts' (Contact DB) should be linked to Event DB or a mixture of both.  Also, how is the information updated in linked DB (I know this has something to do with relational vs lookup).

Anyway, I hope this is enough to get the idea.  I can answer further questions.

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 12 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros