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

• Next in forum: Re: Down or Upload Problem
• Prev in forum: Re: Down or Upload Problem
• Thread view: Re: assign items to more than one category

[Reply to this message]