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})
)