Untitled-1
Dear friends of Interbase list or Delphi list,
I have an interesting proposition, that I think would be instructive for
everyone.
It's about databases in general and specially interbase, if there might be
any difference.
The question is that I have got an Invoice table that has as primary key two
fields, invoice_serial, and invoice_number.
But due to the great amount of invoices, and having the obligation to keep
them at least the last five years, I have been thinking about to insert
another field into the primary key, which would be invoice_year.
So the primary key in the master table and in the detail table (for the
itens of the invoice) would be invoice_year, invoice_serial, and
invoice_number. For the detail table another attribute is code_product.
This information is an extremely valuable asset for everyone working with
any database.
I hope not to have disturbed anyone with my message.
Your well-wisher and friend on the list,
marcelo miorelli
[EMAIL PROTECTED]
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
