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
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)
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)
EventID auto enter serial
Table 3 (contacts)
ContactID auto enter serial
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.
So my second question, do you understand what i mean?