need help with tables

[psych0]

im working on a program so i can inventory the stuff in my house, and i created a form where i can create/edit/view/delete categories and a form where i can create/edit/view/delete items, but i can't figure out how to have the items stay in their selected categories

i have table one

invcats (
icid auto
catname varchar
pk (icid)

and table two

invitems (
iiid auto
itemname varchar
item serial
....
pk (iiid)

---

do i need a table or something to link to two tables together? if someone could point me to a tutorial or sample code that explains how to do this i would be very grateful/

[nemonoman]

You would include a column (or 'field') in your item table called 'categoryid'. Populate that with the (suprprise) category id.

One to many relationship:
One category , many items.

one to one relation:
Each item has one category

Category is a 'foriegn key' in the item table.