yes i have normalised the DB, primary keys and foreing kkeys, the whole shenbang.
why i cannot use one table is because the quote No's and invoice No's must run in sequence and are not always the same, ie I may issue a quote but not make the sale, or i may make a sale without a quote.