Comments by sonsaeng (Top 2 by date)

Thanks for taking the the time to answer. The seal is required in the shipments table, but sometimes there can be 3 seals for each shipment, and one way to get round this is to add the first seal for queries, and then shock horror, add any more seal numbers in the comments/notes field. But this would defeat the object of the exercise, eg as when we get get scanned paperwork and the first seal record is unreadable we wouldn't be able to search on the second or even third seal, and of course the database wouldn't be normalised.