LINES and unique values - 11-07-2009 , 08:32 PM
I have a system for Purchase Orders wherein I select product to be
purchased through a LINES portal referencing a PRODUCT table ID.
Sometimes I need to incorporate miscellaneous entries - entries and
values that are not part of the PRODUCT table (unique to any
particular order). Is there an obvious or elegant approach to marrying
these two needs into one Purchase Order?
Re: LINES and unique values - 11-08-2009 , 02:03 AM
Smurf <wearesmurfs (AT) yahoo (DOT) ca> wrote:
Lines must have an Order ID (foreign key) and may, but do need to have a
product ID. You are free to add lines without product ID
Add a record for miscellaneous to the product table and use this.
In both cases, the line table needs it's own field for text and price
information. You don't want old orders and invoices to change if you
make changes in the order table.