In my experience, having a limit of a particular number of anythings per something, eg. components per compound word is always a mistake, whether it's the number of payments allowed to pay an invoice, the number of children per parent, the number of cars per family, pets per owner, etc. There's always one that has one too many. And lots of them have only one or two. Go for the 'mini'-table.
Jonathan Trahair I'm going to build a translation s/w and I'd like some advice. Many languages have compound words. I'd like to build a table that shows the component words. However, it depends on the compound word as to how many components it has! Now, I could take a "safe" guess and limit it to, say, 4 words. But then I'm wasting a lot of storage. So I thought I'd spawn a mini-table for each compound word. Is that the best way to handle this? TIA, Victor
