I have several tables. One table that contains athlete contact and coach information. Another contains training date/location information. For each training date/location I have the athletes for that particular coach in a portal. What I am trying to do is create a 3rd record in a athlete training log based on that specific traing date that contains attendence and performance information.

How do I pass the appropriate data (athlete name [athlete table], training date [traing log table]) to tie everything together to the third table [athlete training log].

Set Field[]? can't seem to get it to work.

Thanks for any pointers.

DPSEF.zip

Welcome to the Fourm.

I downloaded your file Saturday night, worked on it yesterday afternoon and evening and finished it this morning.

I made some changes. I added a table Team. I think a Team has a name, a coach & a number of skiers. I think Team is more stable than coach. I also added a table Globals.

I re-did the relationship graph.

As I see this there is a one to one relationship between Team and Coach. There is a one to many relationship between Team and Skier. There is a one to many relationship between Team and Training Log. There is a many to many relationship between Skier & Traing Log with Skier Log as the join table.

I have added a script that will run from button in Team layout to add a Training record in Training Log and add a skier record in the Skier log for each member of the team.

I hope this is what you are looking for.

DPSEF_11-19A_RL.fp7.zip

Thanks, I will take at look at what you have done.