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.
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.