Hi, 

I have 2 forms

1st is match fixtures

2nd is corner statistics

match fixtures form has 

match fixture id

match fixture date

corners form has 

corner statistics id

match fixture date lookup

home team

i am trying to populate the home team based on the lookup field of the fixture id

thanks