I am developing Tour Plan application for a Pharma company for MR.

I have 2 forms:

Employee:

Employee ID, First Name, Last Name, Location etc...

Leads:

Company Name, Contact Person, Lead Type, Phone, Address, City

Now i am creating a form called Tour Plan

The First column will have drop down menu to select the Employee First and Last Name. Once selected, it will fill all other information from the Employee table.

The second part is to add Leads. I am using subform. The first column in subform, is giving list of all leads by company name. Selected one, will fill Contact Person, Lead Type, Phone, Address and City.

Along with this, i want to add one more column called Date. The user should be able to select the date (date on which MR should meet the Leads). This date is not coming from the Leads table. It is separate, but should be in the subform.

I tried to find out, but not able to add the field. Can someone help me on the same?