Association Between two tables

[kmmqlick]

Hi All, 

I have one issue on creating association between two tables. I giving details below

I have two table Main table and Project details table.

Main Table:

Project Details Table:

I am not able associate these two table. Please help me to how to link these two tables. 

[rwunderlich]

I looks to me like they link on The "Project" field. 

1. Load the Main table. 

2. Load the Details table. Don't load the fields Program, Domain, Specialization in the Details table. 

3. When loading the Project field in Details, remove the extra info in () with
  SubField(Project, '(', 1) as Project

-Rob