C
CW
I have an Orders .mdb that includes several tabbed pages hanging off a Main
form, plus some linked forms.
frmMain is based on tblInquiries and includes the field/control Ref which is
used almost throughout as the Primary Key and to link together various parts
of the order processing.
frmInvoices is linked by Ref and is used to create sales invoices which are
stored in tblInvoices.
Now I want to have a linked form (Costing) on which I will display all the
costs each order incurs (no problem) and which (now my question) will show
the details of any sales invoices that have been created for that order.
I guess what I need to do is (a) refer to the data in tblInvoices and (b)
select only those records where Invoices.Ref matches Orders.Ref, and display
certain fields in textboxes on frmCosting.
I have made several attempts using either a query based on tblInvoices or
individual textboxes with their sources set to fields in that table, but get
either nothing at all, or #Name? errors.
I'd be very grateful if somebody could spell out the best way to do this.
Many thanks
CW
form, plus some linked forms.
frmMain is based on tblInquiries and includes the field/control Ref which is
used almost throughout as the Primary Key and to link together various parts
of the order processing.
frmInvoices is linked by Ref and is used to create sales invoices which are
stored in tblInvoices.
Now I want to have a linked form (Costing) on which I will display all the
costs each order incurs (no problem) and which (now my question) will show
the details of any sales invoices that have been created for that order.
I guess what I need to do is (a) refer to the data in tblInvoices and (b)
select only those records where Invoices.Ref matches Orders.Ref, and display
certain fields in textboxes on frmCosting.
I have made several attempts using either a query based on tblInvoices or
individual textboxes with their sources set to fields in that table, but get
either nothing at all, or #Name? errors.
I'd be very grateful if somebody could spell out the best way to do this.
Many thanks
CW