Cant Get Object On A Report? Help!?

[alexi]

Hello people.
Could you please help me. This one is a little hard to explain so i;ll try my best.

I have an invoicing system. I Open the form, select which job i want to invoice on from the left list box, then the appropriate task no's for that job appear in the right list box. i select which task no's i wish to invoice and then click invoice. This opens the report with all the info and calculations on it in a nice layout. However, i cannot get a task description on this report, as it is not in the query, and if i put it in the query it produces a cartesian number. Is there another way of getting that field on my report? Perhaps from the form as i have the tasks i want on the report selected already?

I hope someone has an idea because this is driving me insane!

Ta

Alexi

 

[alexi]

Just another addition, i have also tried puttin an unbound text box on the report with the line
forms!frmInvoice!TaskNo.Column(2), but this just brings up the first task over and over again. if i could set some criteria to this parameter that would be good?

 

[Pat Hartman]

If you are getting a cartesian product it is because you don't have a proper join. Is there some field or fields that the tables can be joined on to get the correct. You might need to use a subform if your report is built from two tables involved in a 1-to-many relationship and you want data from another 1-to-many relationship.

For example, if you wanted a report for each student that showed both the parental contact information and the student's classes. You would use a main report for the student information. and two subreports. One for parental contact info and the second for a class list. The subreports are necessary because you cannot create a single query containing all three tables. It would not make any sense because parental contact info and student classes have no logical relationship. They both contain the student ID as a foreign key but that doesn't make them related in any relational database sense of the word.