Problem with displaying two tables

Hello everyone,

I have two tables with this names:

Code:

---

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

---

Code:

---

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

The relation must be from CambioTurno to Equipos

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:

Code:

---

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

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

Hello,

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

edit:
with site I mean page

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.

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:

Code:

---

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

Code:

---

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:

Code:

---

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

---