"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
news:3EF9C93D.BD5E4C8_at_exxesolutions.com...
> Interesting mind read.
>
> My read is that there is a huge data integrity problem if the same invoice
number can exist
> more than once and the entire thing needs to be redesigned. But, given the
limited information
> we have, who can say?
Invoices can have multiple lines, sometimes these get stored in the same
table. There is a design issue for sure, but not necessarily a data
integrity issue.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Wed Jun 25 2003 - 11:26:39 CDT
