Copy link to clipboard
Copied
Hi
i have students table and subjects table and degress table and i want to show the data like this
subject1 | subject2 | subject3 | |
---|---|---|---|
max | 12 | 54 | 56 |
john | 15 | 45 | 34 |
adam | 13 | 45 | 65 |
and the names and the subjects and the degrees are all dynamic so i can add more subjects and more names and there relative degress.
so how to show the data like the above table?
im using DW and ADDT
by the way i use my old way which i repeat region of subjects and repeat region of names and inside the table i repeat the cell of the degree and call a function that reurn the degree based on the current name and subject
thanks in advance.
Copy link to clipboard
Copied
Set a primary key id for each table then use conditional region if key for one table = key for other table echo table field. Repeat region and there ya have it.
Copy link to clipboard
Copied
there is something maybe is missing for all that the degrees table how do i repeat the degrees based on the subjects table
the way i mention works with me but i need another solution
Copy link to clipboard
Copied
I am sorry but I only understand properly written English.