ListPage - Ref Table

February 05, 2019, 08:53:53 AM

Hello
I have a table Employees, and i want to create a leave request for the the employees, in the leave request i have to store the employee who is requesting, the Manager who is approving, the HR who is approving the leave. all these personal ids are stored in employees table, when i try to populate their names on list page i get the Employees table once for selection, I have being doing it by creating those many views on Employee Table as a workaround, is it the only way of there is a better way to do it?

Cheers

Ank

Re: ListPage - Ref Table

Reply #1 – February 06, 2019, 12:22:38 PM

It seems like that your database is highly normalized and that is a good thing. But it also come with a cost of multiple table join when you want to do detailed list page or Form Look Selection.

I would suggest you use the Ajax LookUp on the field data source.
With that your page will only load the required data upon user request.

Thanks.