This gives me some good info. We aren't going to do a calendar. Just a list. Do you span different Time Zones at all? Lisa
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Thursday, February 21, 2008 2:39 PM To: arslist@ARSLIST.ORG Subject: Re: On Call System ** What we do here is give the user's start and end fields so we don't have to have a record per day. A group that may have 1 person on call for a week would only have 1 record instead of 7. When displaying the on call we show any record whose start <= $TIMESTAMP$ and end >= $TIMESTAMP$. To validate on Submit or Modify we check that the Start Date/Time = an ending Date/Time for the same group (or this start is in between another records start/end dates). Showing it in a calander is a bit trickier but can be done. Fred ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Thursday, February 21, 2008 1:01 PM To: arslist@ARSLIST.ORG Subject: Re: On Call System ** The application is going to cover a year. Each group is going to have their own oncall schedule so that our help desk knows who to call after hours for an urgent ticket. We are a 24/7 shop. It's all in Microsoft Access right now (a different access database for each group that I tie in all together through a website). It's horrible to maintain, so we are going to develop something in the AR System (7.0.1 Patch 005, Windows 2003, Oracle 10i) ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ben Cantatore Sent: Thursday, February 21, 2008 1:48 PM To: arslist@ARSLIST.ORG Subject: Re: On Call System ** Lisa, Can you provide a little more information about your app? For example how is the user prompted for his/her oncall schedule? What period of time does this cover, week, month, reoccurring, variable? Just off the top of my head, if you were getting the users to enter their oncall schedule for let's say a month, then all you need to do is a tablewalk check for days missing between the beginning and end of the month. Assuming this was a 24/7 shop. Ben Cantatore Remedy Administrator Avon (914) 935-2946 "Kemes, Lisa" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 02/21/2008 01:11 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject On Call System ** I'm creating an on call system for our company and I would like to make sure that the end user does not accidentally skip a date or a time. So when they are entering information as to who is on call I don't want (this would be in a table): Feb 20 Lisa Kemes Feb 22 Lisa Kemes Feb 23 Lisa Kemes I would like them to see: Feb 20 Lisa Kemes Feb 21 Feb 22 Lisa Kemes Feb 23 Lisa Kemes Is there any easy way to do this? (other than creating a separate table with every hour and date on it). Just wondering/brain storming.... Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"