To establish a link between a main form and a subform you really do not need related fields, you just need related data. You can even link subforms to unbound controls in the main form. The link is basically applying a filter. If you move to a record in the main form explain what records you want to see in the subform. Would help if you showed the sql for both the main and the subform crosstab.