[jfkirkpatrick]

Greetings,

I posted this email under earlier in December 12, 2015 and never received a response so I will try again.

    "A little late to the party but I am interested in this topic.

    I have a spreadsheet with events scheduling for 3 separate rooms with a need to prevent both class and instructor conflicts between rooms.  Displaying it as a single grid would be feasible but require more logic    than having 3 separate grids displayed vertical instead of horizontal.

   Will start following your progress."

 

So what I am trying to do is have a grid using the same table display separate room.  Each event has its own separate row with the key (Not Primary Key) of activityType, courseNumber, eventStarDate (a DateTime field), Room eg:  C, 101, 2016-04-23 09:00:00, D (Class Type = C, Course Number 101, date, Room D).  There could be a class C, 105, 2016-04-23 09:00:00, E.

 

Thanks

 

John

 

[jfkirkpatrick]

I have not been able to get this to work but was able to with a different product!!

The problem is I created 3 grids side-by-side and what I really want is 1 Grid with columns from the same table displayed by different sequence.

What I have is an event file that contains records by:

• eventID - Primary Key, autoincrement
• activityType
• courseNumber
• eventStartDate - Format yyyy-mm-dd H:i:s
• eventEndDate -  Format yyyy-mm-dd H:i:s
• eventLocation 
• eventInstructor

I want the events to be separated and displayed by Room Number (eventLocation) so the Grid will display by StartDate/Time all events for Room C, Room D and Room E.

I did a Google search that brought up several responses indicating that set_relation might be the way to go as I will have to use MySQL Alias in the select statement.

In advance, thank you for your help.

John K

Example

 

ROOM C                                        ROOM D                              ROOM E                            

DATE      TIME    Class Instructor TIME      Class Instructor        TIME      Class                Instructor                                                        

11/01/14 9:00 AM                         9:00 AM Web Team               9:00 AM                      

11/03/14 9:00 AM                         9:00 AM File Expl-W8 Betty   9:00 AM                    

11/03/14 1:00 PM                         1:00 PM Quicken Doris          1:00 PM                       

11/04/14 9:00 AM                         9:00 AM File Expl-W8 Betty    9:00 AM Oper Sys II-W8 Bob H