data entry 3tables 1 form

[gbmarlysis]

hi,
i want to create a form where i can enter in
1- an athletes name (then his details come up eg dob)
then
2- enter in the race he ran in (if its a new race then plots in table if its a race entered already then the other details come up eg distance date)
then
3) enter in the athletes position in the race his time etc

and then at the bottom of the form as i put in their name all the races and positions they have run (so i know what needs to be entered)

i currently have three tables
1-athletes
2-races
3-race details

Can any one help me with this form please...is it possible..people say anything is possible in access..
many thanks lb

 

[MStef]

Yes, it is possible. Make a MainForm on the ATHLETS table, and make
2 subforms, (on the RACES table, and the RACE DETAILS table).
Link them all via AthletsID (number).
Populate a LINK CHILD FIELDS, and LINK MASTER FIELDS properties
for the both subforms.

 

[gbmarlysis]

Hi Mstef,
Created to subforms but what do you mean link them by athleteId and what do i put in the master and child field for each subform
TY
Lb

 

[MStef]

Look at "DemoAthleteA2000.mdb" (attachment, zip).
Look at Tables, Forms, Relationships.
Look at LINK CHILD FIELDS and LINK MASTER FIELDS properties in
the both subforms.
I entered 1 record in the frmAthleteMain (tblAthlete), and 2 records
in both subforms.
Open frmAthleteMain and try to enter a new Athlete, and for him a new
data in both suborms.

 

[gbmarlysis]

Hi Mstef,
Thankyou so much for the example, i just have to have dinner, then i'll look through it and see if you have solved it for me.
Thanks again
LB

 

[gbmarlysis]

Hi Mstef,
im just trying something else for the moment im going to try having the raceresults as the main form and then two combo boxes to pick the athlete and race, with new entry buttons to the side. But thanks again i might end up crashing an burning and coming back to your way..
TY
LB