Lookup Field Help

[JPRENG]

I have got a a form storing all employee's information and on that form I have a lookup field which looks up all the records in the "Qualification table" and the user can select multple qualifications. What I want to add to the lookup field is a data box so you can select a qualification and then enter the date that it expires (different for expiry date for each employee) How do I do this?

I have added the date field to the qualification table but when I create the lookup field on the form it shows the qualifications and a blank column next to it which data can't be enteed into.

 

[PaulO]

You're going to have to bring the Qualifications table as a linked SUBFORM of your main form.

You'll need to add Employee ID to the Qualifications table, and this field will facilitate the necessary Parent/Child link between the MAIN and SUB forms.