<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.00.3314.2100" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=460095414-28032003>If a table used for
requesting assistance has numerous fields that will be listed as checkboxes or
yes/no type fields is it better to list them all in the same table? There may be
up to 20 or so total. Would the help needed list & the areas list be in the
same table with the Request? They can check more then one of the
items.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460095414-28032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=460095414-28032003>If they do check -
mouse for the problem and the review shows they need to order a new mouse, later
on the coordinator will order the mouse and needs to track the brand, vendor,
etc for the mouse order.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460095414-28032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=460095414-28032003>For
example:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460095414-28032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460095414-28032003>RequestID</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=460095414-28032003>EmployeeID (from
tblEmployee)</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460095414-28032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=460095414-28032003>(This group lists
the help needed)</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460095414-28032003>Chair</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460095414-28032003>Monitor</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460095414-28032003>Mouse</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460095414-28032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=460095414-28032003>(This group lists
areas)</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460095414-28032003>Neck</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460095414-28032003>Finger</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460095414-28032003>Shoulder</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460095414-28032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=460095414-28032003>The requestor marks
all areas</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460095414-28032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=460095414-28032003>Virginia</SPAN></FONT></DIV></BODY></HTML>