Problem with displaying two tables

[mac-duff]

Hello everyone,

I have two tables with this names:

CambioTurno

FechaHora            	IdEquipo	Dia
05/03/2010 18:21:50	1	05/03/2010
05/03/2010 18:23:49	1	05/03/2010
05/03/2010 18:24:16	1	05/03/2010
05/03/2010 18:25:54	1	05/03/2010
05/03/2010 18:26:01	3	05/03/2010

Equipos

IdEquipo         Equipo
0                     NoName
1                     User1
2                     User2
3                     User3

No I would like to print on each page header the TimeDate and the Username. Means when I ask for this date (5-3-2010), I want to get 5 pages with everytime the date and the name.
I dont know what I am doing wrong with the link tables but mostley I get just 2 pages with both names, but not 5 pages with this two names.

In the Database Expert -> Links I have connected those both tables with a '>' => Equipos.IdEquipo --> CambioTurno.IdEquipo.

I hope someone can help with that.

Thanks

[jggtz]

The relation must be from CambioTurno to Equipos

[mac-duff]

Hi,

thanks for your answer. I ve tried it and of course other ways but it wont work.

What I want right know to have in the page header:

Site1:
05/03/2010 18:21:50 User1

Site2:
05/03/2010 18:23:49 User1

Site3:
05/03/2010 18:24:16 User1

Site4:
05/03/2010 18:25:54 User3

Hope u understand my proposal

[jggtz]

Site1, Site2...SiteN
Where they come from... another table...?

[mac-duff]

Hello,

just put SiteN for the count of pages I would like to get

edit:
with site I mean page

[mac-duff]

I think I found a way.

With the group expert I have created a new group for the datetime and print this for seconds.

Next point I did is in the section expert and say new page before.

[mac-duff]

I see another problem.

I said in the group expert that the print will be done for each second.

but one entry for example will not be displayed:

FechaHora	IdEquipo	Dia
2010-03-05 18:25:54.000	1	2010-03-05 00:00:00
2010-03-05 18:26:01.000	3	2010-03-05 00:00:00

The second row will not be displayed because it is less then one second.

Any idea?
-------------
Edit:
ok, I ve put it directly in the detail section and said new page for each.

Now I am coming to my next problem

Dia and IDEquipo are connected with another table which can look like this

IdEquipo	Dia	NumMoldes      Ok
1	2010-03-05 00:00:00	4        1
1	2010-03-05 00:00:00	4        1
1	2010-03-05 00:00:00	4        1

Right now I get for this date in the detail section:
05/03/2010 18:21:50 User1
which is ok, but now I want to add the NumMoldesSum which would be in the example 12, but every time I enter this I get 8000 pages becasue it is using the complete table. Here is my code:

If {Produccion.FechaTurno}={CambioTurno.Dia}
then
If {Produccion.OK} = 1 Then
(
 Sum({Produccion.NumMoldes})
)