Form - subform - Master - Child problem

[wokkie]

Hi,

I have just converted an Access Mdb to an ADP, using Access 2003 and SQL Sever 2003.

I have a problem with one frm with a subForm, the records are not filterd, so all the records in the subform are shown, not just the relevant ones.

The subform is populated using a proc which is a union qry of two other views.

I think the problem is that the key in the Master form is "int" and the one in the subForm is "Real", I expect due to being from a proc.

How do I resolve this? A problem similar to this is mentioned in thread958-589560

Thanks

Ian

 

[wokkie]

Solved,

I added a parameterto the proc, the link key, and now it works as it should do.