Posted by J.O. Aho on 12/09/06 12:55

Dave Nash wrote:
> hi All,
>
> I have created a database with two tables, categories and items.
>
> How do I go about assigning a particular item to more than one
> category?
>
>
> <Categories table>
> Catid
> Catname
>
> <Items table>
> Itemid
> itemname

Create a relation table

<ItemCat table>
Itemid
Catid


//Aho

[Back to original message]