How to use 2 numeric values in one table field?

[airski]

I have a ms access database with 9 products and 10 categories. I am using asp to call the products and categories to display on a webpage. My problem is that each category can only display one product? I can't put more than one value in my products table (category field) because it is a number. How do i do this? I want to be able to put as many products under one category as i want?

Example:
If you click on the link Category 1, i want it do be able to display products 1,5 and 9? It only displays product 1 because i can only put one number in that field?

I would really appreciate some help!

Thanks,

Airski

 

[airski]

I figured it out! Sorry.