Access 2013 - linking tables

Hi Anjali

You may need to say little more about your question. But it sounds like you have an Attendance table and want to ener information drawing it from the your Contacts table.

To do that first create a primary key field in the Contacts table. For example Contact ID. This could be an Autonumber field and make it a Primary field usually the first one.

Then create an Attendance table including the Contact ID field as a Number field type. The other fileds would be event name, date, attended etc.

Finally go to Database Tools Relationships and link the Contact ID fields.

After entering the Attendance info you can then produce Reports or Forms that combine information from both. For example you could create a schedule of events listing the names and and phone numbers of attendees.

Please let me know if that helps.
Regards
Doug Dunn
Best STL