[AccessD] Table of checks

Hollis,Virginia HollisVJ at pgdp.usec.com
Fri Mar 28 09:11:03 CST 2003


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.
 
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.
 
For example:
 
RequestID
EmployeeID (from tblEmployee)
 
(This group lists the help needed)
Chair
Monitor
Mouse
 
(This group lists areas)
Neck
Finger
Shoulder
 
The requestor marks all areas
 
Virginia
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030328/f9aac81a/attachment.html>


More information about the AccessD mailing list