Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need some help, as subject says, in how to create a new table from the relation of 3 other tables.
Example: I have three tables, "StudentId", "Subject Name" and "Grade". And I want to create a new one with all students grade for a specific subject. It means.. instead of show Student ID's, this new table will show all student grades of, for example, Math subject.
Thanks in advance
hi,
You can use join function, to get all three tables into one.
eg:
Load StudentID, Name, SubjectID,GradeID from Table1;
join
load SubjectID, SubjectName from table2;
join
Load GradeID, GradeName from table3;
Can I use that join function on table (the new one) properties as an expression?
hi,
You have to do it an script level. not on front end.
hi,
If you want three tables data to be in one in front end then just link the three tables.
You have to make sure the field names are same to link it. The add the fields in Pivot or Straight or normal table.
Ok, i'll try.
Thanks a lot 😉