On 8 Feb, 05:35, ThanksButNo <no.no.tha...@gmail.com> wrote:
>
> Add a new table -- call it, say, "edibles".
>
> Columns: unique_seq, edible_type
>
> As you add fruits, add (new unique_seq, 'fruit'), to this table, then
> set 'fruit_id' to that new unique sequence for the fruit table also.
>
> As you add vegetables, add (new unique_seq, 'vegetable') to this
> table, same with sequence again for the 'veg_id' column.

Ah, of course. I had a feeling I was missing something obvious.
Sometimes I just can't see the wood for the trees.

Many thanks.

Have yourself a slice of regiftable fruitcake.