Hello. 

 

I have a regular setup Items | Line Items | Invoices | Customers

 

Line Items and Invoices are related through an Invoice_ID field.

 

The database is a record of all school lessons for a particular teacher in any given month.

 

My Items table is actually a table of different Lesson Types. When I am entering lessons, each lesson has a

start time and date.

 

I can see all lessons for any given teacher for the whole month on the invoice table in a portal [ portal is showing Line Items entries ].

 

The thing is that lessons are all in the portal [ as they should be, no issues ] one below the other, for example :

 

Lesson1 Date1

Lesson2 Date1

Lesson3 Date2

 

I would like to add a monthly view sorted by date:

 

Date1           Date2          Date3

Lesson1       Lesson1      Lesson1

Lesson2       Lesson2

Lesson3

 

I am getting stuck here, not sure how to relate the table to get what I want.

 

Any help is appreciated

 

* Please see the screenshot of my relationship graph [ attached ]

 

Thank you kindly.,

Attachment added.

Very briefly:

 

1. Calendrical displays are never simple.

 

2. This would be significantly simpler in v.11 or higher, where you can filter each portal to show events for a specific date only. Otherwise it gets (even more) complicated.

Hi. Thanks for the reply. Don't have the $$$ for v.11 so will give up on it for now. Will post here if I can figure it out in a different way. Got a few ideas I am trying now.

 

Thanks.,