I have 3 forms - Machines, Drawings and Works Orders

Works orders has a look-up field to drawings so you can select the drawing number for the order (as well as other fields in the Drawing form). But the Drawing form as a sub-form which links to Machines. This is where information is store for how the part is made and times, etc.

Under my view for Works Orders - I can't get it to show up the relavant fields from my Machines form (the sub-form in the Drawings form). Is there a way to display this data properly? At the number it just shows up numbers. Or is there a limitation on using Sub-forms.

I hope this is some what clear - my application has remote access if someone wants to look a bit closer.

Thanks in advance

Ben