Form with Subform

T

Tiago Patrício

Hi everybody. Hope someone can help.

I have 3 tables: Group (description of companies), Ratios (Financial ratios
names and description) and Group-Ratios (where I put the values of the ratio
to each company group per year)

The fields I have:
Group table: Grp_id, Grp_name ...
Ratio table: Rat_id, Ratio_name ...
Group-Ratios: Grp-Rat_id, Grp_id, Ratio_id, Year, Value

I have one to many relationships between the Group and Ratio tables to
Group-Ratios.

I needed a form where I would have the Group names (being able to circle
through them), with a subform where I would show the values.

The problem is that I needed to have a subform with this type of appearance:

2003 2002 ...
Ratio_1 ratio1_2003_val ratio1_2002_val
Ratio_2 ratio2_2003_val ratio2_2002_val
..... .... .....

However, I tried and tried and can't do it

Can anyone help??

Thanks
 
Top