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_category_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_category_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.