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.