People have many events
Events have many People.
A Join Table is needed, called Attendance? Attendance has one People and one Event
People are related to Attendance
Attendance is related to Event
I now have 2 files. I created a file and called it Main Data Base. There is one table, 4 fields; Name; Email Address; Phone; Cell.
Then, in the file ( "File Two" ) where I want those fields to automatically fill, I started with Manage External Sources and added Main Data Base to the list of sources. I created a relationship between the Main Data Base and the tables in "File Two."
From the Drop Down list for Name, I see the list of names that are in the Main Data Base. But when I click on a Name to select it, I get a pop-up error that says:
"This field cannot be modified until "Email Address" is given a valid value."
In my Main Data Base file, all the fields are filled in. I'm missing something, but I can't figure out what it is.
Seems like I'm close, but I'm just missing something that's preventing the fields from filling correctly.