- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2024 04:56 AM - edited 06-12-2024 04:57 AM
I have 2 table. The 1st table name is User Tracking and the 2nd table name is User attendance. I have multiple data of a single user in the user tracking table and but only one data in the user attendance table. So i want to display the user tracking data in the user attendance table in related list
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2024 05:06 AM
@Pratham Singh Please refer to this documentation to know how a related list can be added and filter can be applied
In the example Applies to table and queries from table are same. But in your case Applies to table will be user attendance and queries from table will be user tracking.
Also in the filter you can use
current.addQuery('u_user',parent.u_user); //Assuming both the tables have u_user column parent here is the record of user attandance table.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2024 05:06 AM
@Pratham Singh Please refer to this documentation to know how a related list can be added and filter can be applied
In the example Applies to table and queries from table are same. But in your case Applies to table will be user attendance and queries from table will be user tracking.
Also in the filter you can use
current.addQuery('u_user',parent.u_user); //Assuming both the tables have u_user column parent here is the record of user attandance table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2024 05:47 AM
Thankyou for your accurate response. It solved my Query.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2024 05:51 AM
@Pratham Singh Glad to know the solution helped 🙂