some one help me with this report

reddy

New member
Local time
Today, 03:47
Joined
Apr 20, 2005
Messages
9
I have a from called invoice in which i give the From_Fiscal_Year which is a number and To_Fiscal_Year and the Project_# of that project for which iam trying to generate the invoice. In this I have a Print Report button when i am trying to print the report i am not able to take the information about the Particular project which i gave in the form, like its billing address which is in the Project table.How do i pull this information.

Billing info must be equal to the billing address in the project table where the project_# in invoice form is equal to Project_# in projects Table.
 
Is your invoice form bound to a table?

If so you can base your report on a query that joins the 2 tables on the project# field.
 

Users who are viewing this thread

Back
Top Bottom