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>