<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.4712.0">
<TITLE>Table design</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">I currently have the following <snipped> table designs -</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Products:</FONT>
<BR><U><FONT FACE="Courier">Product Christmas Easter AllYear Major Corporate</FONT></U>
<BR><FONT SIZE=2 FACE="Courier">Product 1 True False True False True</FONT>
<BR><FONT SIZE=2 FACE="Courier">Product 2 False False True True False</FONT>
<BR><FONT SIZE=2 FACE="Courier">Product 3 etc'</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">OrderType:</FONT>
<BR><U><FONT FACE="Courier">OrderType Christmas Easter AllYear Major Corporate</FONT></U>
<BR><FONT SIZE=2 FACE="Courier">Christmas True False False True False</FONT>
<BR><FONT SIZE=2 FACE="Courier">Easter False True False True False</FONT>
<BR><FONT SIZE=2 FACE="Courier">AllYear False False True True False</FONT>
<BR><FONT SIZE=2 FACE="Courier">Corporate True True True True True</FONT>
<BR><FONT SIZE=2 FACE="Courier">Major False False False True False</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">In Order Entry, the user selects an "OrderType" in the header and I then need to check for each line item, if this product is allowed for this "OrderType".</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Now this works, but does require quite a bit of code to test each variation, but more important, it also makes maintenance a pain. If I now need to add a new OrderType, I have to add a record to the OrderType table (no problem with this), but also add a column to the Products table and then re-work the code to check the order line items.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">There has to be a more elegant and easier to maintain way of doing this, but I can't see it.</FONT>
<BR><FONT SIZE=2 FACE="Arial">Any ideas please?</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Many thanks</FONT>
<BR><B><I><FONT COLOR="#000080" FACE="Times New Roman">Tim</FONT><SPAN LANG="it"></SPAN></I></B><I><SPAN LANG="it"></SPAN></I><SPAN LANG="it"></SPAN><SPAN LANG="it"> </SPAN>
</P>
<BR>
<BR>
</BODY>
</HTML>