By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,853 Members | 1,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,853 IT Pros & Developers. It's quick & easy.

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

P: 1

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

I have 3 tables.

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

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):
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.
Dec 16 '09 #1
Share this Question
Share on Google+
1 Reply

P: 83
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.
Dec 18 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.