From an efficient database design point of view, you'd want to look at
using a two-table method for this, for example....
InvoiceHeader Table
InvoiceNumber
InvoiceDate
Customer
InvoiceItem Table
InvoiceItemId
InvoiceNumber
ProductCode
Quantity
Price
Discount
etc
that way, if you want to calculate discounts etc etc, you can use SQL
Aggregate functions (COUNT, SUM etc) to get the values back from the Item
table for the relevant Invoice.
Hope this helps
Nick
At 00:56 18/05/00 -0700, you wrote:
>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.
===========================================
Nick Slay
Technical Director
Webbods Pty Ltd (ACN 086 160 189)
PO Box 4047
Copacabana
NSW 2251
Tel: 02 4381 0284
Mob: 0414 810284
===========================================
Join the BodNews mailing list for News/Announcements
and Offers from Webbods. Send an email to
[EMAIL PROTECTED] with 'subscribe bodnews' in the
subject line.
===========================================
Proud Sponsors of the Northern Eagles NRL Side 2000!!!
------------------------------------------------------------------------------
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.
