TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
Related Tables as Details under Summary
This may be a bit of a fringe use but ...

If Table-A is in a Master-Detail Rel'n with Table-B then the details in Table-B ought to be visible as a set of details under a summary of Table-A data if there is a Common reference point in Table-A. Like a common DATE in a Calendar shared with a number of records in Table-B that may or may not share a common time reference from Table-B.

Ie: 12 records in Table-A share the same DATE which is the common value linking them all in Table-B. In Table-B the Times are all broken down to be displayed in a familiar format for users. This could be the set as a VIEW in Table-B that then becomes the DETAIL records displayed when the Calendar DATE is clicked rather than being limited to just the views in the Master Table-A.

I have several places where the ability to display related details from a Master-Detail relationship as the details page behind a summary (a Calendar for instance since this is my current hang-up) would be very handy.

While the Details of such a relationship can be displayed below a specific record, the current arrangement does not allow for a similar detail of records from a 2nd table that share common data to be displayed as the details of a summary.

In the case of a scheduling calendar we use, I have a 2nd table which holds the data in 15min intervals for scheduling which then is accessed in a summary rel'n just to get it back into the Master Record table so it can be displayed in a calendar format and, via VALIDATIONS and other measures, prevents users from creating a scheduling overlap. It works but this would be SOOOOOOOOO much simpler to display and make work, and far more familiar to users if , when they click the date to view details, the underlying DETAILS table could simply be a VIEW from the 2nd table. And wouldn't it be even better if the drag-and-drop functions worked in that VIEW TABLE environment so a user could click on a record and drag it to a new available time slot?

A calendar is just one example where I have a use for something similar, the best use example perhaps but not the only one.

Just puttin' it out there.


calvin peters
Date Created
4/29/2021 1:46:13 PM
Date Updated
4/29/2021 1:46:13 PM
New Idea
Promoted By
calvin peters
Back to Search Results