I am working on a CF-based invoice log system (one
module of a Sales Management System). At present we
use Excel with the following columns:
InvoiceNo
InvoiceDate
Customer
10 product code columns (one for each product)
TotalDiscount
Invoiced amount is entered under the specific product
column. Excel sheet shows rows of invoices with list
of products (with their amounts). We can easily find
total invoice amount for a specific product, total
discount given, etc. - just by summarizing a specific
column.
We want to have the same benefits plus other added
benefits in the CF based system. I can achieve the
same benefits by creating a table with same number of
database columns. But I don't want to fix 10 columns
for 10 products (as the number of products could
change). I am thinking of using Select List.
Kindly suggest a best table structure for this
situation.
Thanks for your help.
Naveen
__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
