469,929 Members | 1,629 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,929 developers. It's quick & easy.

grocery list in access

pdb
I want to make something so I can make a grocery list easy and just print it
off. I am guessing I would have a drop down list, which would be a list of
tables, then select item from the table. For example, first I want milk, so
in the first drop down list i choose dairy, then select milk. Is there a way
to do this and have an add button so it adds it to a list (report)?

Thanks Paul
Nov 12 '05 #1
5 3085
pdb
Is it best to have a list of tables, and then the item?
Nov 12 '05 #2
rkc

<pd*@none.com> wrote in message news:EHuzb.213354$Dw6.777468@attbi_s02...
Is it best to have a list of tables, and then the item?


Just have your mom make the list.
Nov 12 '05 #3
pdb
Just be an ass. Why waste your time posting garbage? So I am trying to learn
Access and doing something that may also be used for other things. Whatever,
get a life.
Nov 12 '05 #4
Actually, Paul, you have a good idea, one that I tried to set up
myself.
You don't actually need separate tables for each category (e.g. Dairy
items, breakfast cereals, condiments, etc.).
However, good relational DB theory says you should have a table of
categories (with a key, say an alphabetic key), and a table of items
(item name, category key). The item table could also have a key (for
indexing/sorting).
Your form could have the following:
Combo box or list box with the categories. When you select a category,
a second combo box or list box could be filled with the items in that
category. When you select an item and click an OK button, you could
copy the item into a table of items (starts as empty). The contents of
the table could be shown using a third list box, which could be
Requeried after every addition (to keep it up to date).
You may also find it useful to have a mechanism to remove items from
the displayed list (and the underlying table), remembering to again
requery the data source for the list box after deleting.
HTH
Perry Zamek
Nov 12 '05 #5
Jon
I already have one made up. It has dropdown list of groceries (not by
category), but if you enter something that's not in the list, it asks
if you want to add it to your lookup table. It also has a field for
prices and even the aisle in your supermarket, so if you want to take
the time to enter the aisle numbers for each one, it will sort the
printed list by aisle next time. If you'd like to see it, email me
and I'll send you a copy.
pd*@none.com wrote in message news:<U8xzb.411987$Tr4.1186893@attbi_s03>...
Just be an ass. Why waste your time posting garbage? So I am trying to learn
Access and doing something that may also be used for other things. Whatever,
get a life.

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Kyle Teague | last post: by
10 posts views Thread by Jason | last post: by
4 posts views Thread by Tony Toews [MVP] | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.