Double Records

[jamesT]

Hi all
I have a form which displays students results. Each student can take a module in different Terms and years.

I have created a filter to filter the Years and terms. But i get duplicate values in the main form and subform and the filter will not work

If any one thinks they an fix this

It would be great to know how

Thanks

 

[Jack Cowley]

Add your Year and Term combos to the main form. Set the Child link for Term;Year and the Master link to the two combos.

hth,
Jack