inputting and lookingup? newbie question

[hrov]

i have created a data entry form and just realised i have done it terribly wrong.

Lets say i want to enter an athletes times into this form. (so the times in seconds is what i am creating/entering). this part works ok.

But when i input a athlete it adds this athlete to the atthlete table I DONT WANT THIS. I am merely selecting a swimmer not trying to create a new one.
so i am trying to do the following ---> select athlete A and input a time.

what i am not trying to do is input/create a new athlete and input /create a time.

Where am i going wrong and how do i go about creating a entry form/lookup/assign form

 

[John Big Booty]

Sound like your forms and tables aren't set up quite right. Have a look at the sample DB.

You would probably also want to record the Meet at which the result was recorded. All you would need to do is add anther table called (for example) TBL_Meet, add MeetID to the current table TBL_Result and add an additional Combo to Form FRM_Results.