Hi,

Could someone please help us with the following issue:

We have two forms, one form called "atleta" and other form called "treinos". 

In the atleta form we used to record the data from our athlets (we are a indoor rowing club in Salvador, Bahia, Brazil). In the "treinos" form we recorded the workouts from our athletes.

In the "atleta" form we have a field called "peso" to register the weight of the athlete.

We need to use the weight of the athlet in a formula to calculate the calories burned in the workout.

We try to use the relationship option, but the dropdown field shows the weight of all the athlets registered. What we really need is something for, when we choosen the athlet name in the "treinos" form (a relationship field who works good) the weight of the athlet choosen will be automatically recorded in the "pesoinformado" field.

"atleta" form:

Name of athlete = field named "atleta"

Weight of athlete = field named "peso"

"treinos" form

Name of the atleta = Field of relationship that shows troug a dropdown all the atletas registered in the "atleta" form.

Weight of the atleta (in the treinos form)= field called "pesoinformado" wicht server as the basis for a formula to calculate the calories burned during workouts.