How to call multiple tables into one interface?

Hi ,

If you have two or more different table with no dependency or relationship among them like Student(StudentID,StudentName,..), Qualifications(QualificationID, QualificationName,...), etc., you can use two different query entities to get the details.

If you have two or more different table with dependency or relationship among them like foreign key, you can create a view, create cdt for view then using query entities get the details. This will reduce the load on the interface when there are huge records. When it takes more time to load the data, screen will be showing working or it makes some delay in displaying the results. So we can avoid performance and user experience issue.

Hi ,

If you have two or more different table with no dependency or relationship among them like Student(StudentID,StudentName,..), Qualifications(QualificationID, QualificationName,...), etc., you can use two different query entities to get the details.

If you have two or more different table with dependency or relationship among them like foreign key, you can create a view, create cdt for view then using query entities get the details. This will reduce the load on the interface when there are huge records. When it takes more time to load the data, screen will be showing working or it makes some delay in displaying the results. So we can avoid performance and user experience issue.