Displaying fields from 5 tables on a form

[sv89]

Hi,

I've attached my relationship diagram.

I want to create 'frmInvoice' which displays the following fields:

All fields from 'tblInvoices'
ServiceID, AppID from 'tblOrders'
addLine1, addLine2, addLine3, town, county, postCode from 'tblAppAddresses'

Also I want to let the user select which of the orderlines (from 'tblOrderDetails') s/he wants to invoice.

I'm at my wits end as to how to go about doing this.

I've created 1 subform within a mainform before but any ideas how to do this?

Thanks

 

[sv89]

Oh, I figured out the link property.
Always just dragged the subform on to the main form and thought it would work automatically everytime.