AnsweredAssumed Answered

Scheduling problem

Question asked by gunnerstudio on Jul 17, 2009
Latest reply on Jul 17, 2009 by gunnerstudio

Title

Scheduling problem

Post

Hey

 

I have created a easy weekly scheduling layout. (7 portals) + 1 portal that shows half and hour time slots.

 

Here is following tables and relationships 

 

Relationship 

table 1(schedule) x table3(contacts) (I created one field in contacts and one field in schedule created and "x" relationship, afterwards i deleted them so in the relationship table is said "unknown x unknown"

!! i know this seems Odd, but it works. 

 

Events::Start_time = schedule::cSchTime 

Events::Date = schedule::cSchDate

Table 1 (schedule)

 

Fields

cSchID, | auto enter serial

cSchTime | Mod ( SlotID - 1 ; 48 ) * 30 * 60 //calc end

cSchDate | Let ( [

sunday =Contacts 2::gDate - DayOfWeek ( Contacts 2::gDate ) + 1

] ;

sunday + Div ( SlotID - 1 ; 48 ) 

)

 

Table 2 (Events)

 

Field

EventID auto enter serial

EventType (text)

Start_time

End_time 

Date 

 

Table 3 (contacts)

 

Field

ContactID  auto enter serial

cWeekDatesR 

gDate 

Name

Adresses

Etc...

 

 

 So far so good. 

 

The all the Portals shows related records from Schedule shows one Field from Event (EventType)

Each portal got 20 rows, showing each half an hour after 08:00 and ends at 17:30 as the calc inschedule::cSchTime shows.. (08:00, 08:30, 09:00 etc..)

 

don't worry everything work so far.... 

 

When I make an Event (Date 17.07.09) (Start_Time 08:00) (End_Time 10.00) (EventType Lunch )

 

 

It shows perfectly as and planed, it is Lunch as 08:00 but it show is end at 08:30. How can I make so EventType show until End_Time (10:00)

 

 

I tried to create a new field in Schedule called cSchEnd_time, an create a relationship  "Event::End_time = Schedule::cSchEnd_Time. The portales doens show any data.

 

Please help

 

 

So my second question, do you understand what i mean? 

 

 

Kind Regard


Outcomes