ACCESS: Continuous Form, List Products Show Multiple Categories for Each Products.

[realayumi]

ACCESS 2003
WIN XP

Hi, i'm new in access, just a view days, this is my first post.
Sorry for my bad English.


I have 3 tables.

tbl_product
product_id (primary) | product_name | product_price
1 | short | 100
2 | skirt | 120
3 | cap | 50

tbl_product_cat egory_xref (no primary)
category_id | product_id
1 | 1
2 | 2
1 | 3
2 | 3

tbl_category
category_id (primary) | category_name
1 | Men
2 | Ladies

Before, i want to list all product using continuous form, and using listbox to store multiple categories.
First, query the product, then in listbox source from query the categories taken from txtproduct_id (textbox).
The plan is like this image (i used PhotoShop to edit the image to make easy to explain), then i get error, and confused.


Then i read that many people say we cant do that in continuous form.
But i must use continuous form. It will take long time if i check the product 1 by 1 page.
Actually i dont need to edit the product's categories, i just want to know which categories the product is.
Any idea how can i show each product's categories?

Maybe create first query tbl_product_cat egory_xref and tbl_category to get category_name and automaticaly create temporary new

table (i dont know access programing) that combine category_name with "," separated each same id
SAMPLE NEW TEMPORARY TABLE (can be replace every time we open the form):
tbl_product_cat _temp
product_id | category_multi
1 | Men
2 | Ladies
3 | Men, Ladies

Then second qury for continuous form that displaying all products and connect to tbl_product_cat _temp,
and store this category_multi into textbox. Is this posible?
I really need this solution, and really hopeless...
I dont know where to get help. Nobody can use access in my area.
Thank you in advance.

[orangeCat]

First, a suggestion.

Tell us what you are trying to do.
Help us understand your problem/situation. We do NOT know your application nor data.

Don't tell us how to do it, just tell us what you're trying to do.