F
FrunkaBlunka
Hi everybody,
I am trying to make a datbase that a prints report that will be used as
an invoice
I am trying to eliminate the need of typing the same clients name,
phone, fax in every single record. I have created a table
(tblClientDetails) where I have added all the clients that I deal with.
On my main form (frmProjectDetails) I have created a combo box that
lists all the different clients. Once selected I would like the combo
box to show the details of the client on the report called
(rptTaxInvoice) using the data in the (tblClientDetails) All the tax
invoices are unique identified by there JobID. When I tried to do it I
got it to work to an extent but the client was the same for every tax
invoice and never changed when navigating through the database.
There is something simliar in the orders form of the Northwind
database which in is perfect I just can't translate it to mine.
Forms
frmClientDetails
frmMain
Reports
rptTaxInvoice
Tables
tblClientDetails
tblProjectDetails
Hope that makes sense
I am trying to make a datbase that a prints report that will be used as
an invoice
I am trying to eliminate the need of typing the same clients name,
phone, fax in every single record. I have created a table
(tblClientDetails) where I have added all the clients that I deal with.
On my main form (frmProjectDetails) I have created a combo box that
lists all the different clients. Once selected I would like the combo
box to show the details of the client on the report called
(rptTaxInvoice) using the data in the (tblClientDetails) All the tax
invoices are unique identified by there JobID. When I tried to do it I
got it to work to an extent but the client was the same for every tax
invoice and never changed when navigating through the database.
There is something simliar in the orders form of the Northwind
database which in is perfect I just can't translate it to mine.
Forms
frmClientDetails
frmMain
Reports
rptTaxInvoice
Tables
tblClientDetails
tblProjectDetails
Hope that makes sense