Report problems displaying names

[jobro]

So I have a report that will work as an reciept that we get when we are recieving an request to deliver. The report shows the following information.

<date>
Today we recieved a request from:
<request person>
The task is:
<task name>
The one to do it:
<task person>
More information
<info>

The problem is that I need to specify the task person and the request person's names from two related tables. The problem is that when I asign the names then I get two prompts for what to replace these with when I show the report. So can anyone help me out with what I'm doing wrong? I'll ensure that I submit a database since it has no important information as of now.

 

[rainman89]

is there a form open that has the persons names on them when you print the request?

 

[jobro]

Uh no it ain't any forms shown at all.

Here is the database.
http://www.speedyshare.com/869717722.html

It will launch a form at startup. It has alot of hidden tables and report so make sure to enable the view of hidden objects.

Anyway the report that fails is the report Kvitton.

 

[rainman89]

you should base your report off of a query, that way you can link the related tables together. as you have it now it is based off a single table only. there is no way for the report to grab from the other table

 

[jobro]

Ok can you give some more information how I should set this up? So damn noob at access.

 

[rainman89]

use the wizard to create your query.. insert the proper fields from the correct tables and, if your relationshsips are set up correctly, your query should give you what you need.