Hi, I'm working on an inventory application, and have a question about the database design. I have an "articles" table. An article could be, for instance, a modem. The same modems all have different serial numbers, and could come from a different suppliers, maybe at a different price, yet they are the same article. On the other hand some articles, like "phone cable" doesn't have a serial number. When an article leaves stock, we'd like to be able to say: sold: modem with serial nr111 3 x phone cable So I'd like the phone-cable to be booked on a first-in-first-out system, and the modem to be selected by serial-number. Am I right to combine these two in the same tables? I am currently going with two tables, like this: Articles: artID type make model description priceOut termsOut Articles Detail: artDetailID artID supplierID priceIn serial termsIn dateIn dateOut and linking Articles to Articles Detail by artID in a one to many relation. Would that be a robust setup, or am I overlooking something? Thanks, Richard.