Access 2000 Grocery List Database

[Jennifer]

Hi!
I am trying to make a Access 2000 database with my
grocery list. What I want to do is set it up so when I
make a new grocery list and type in, let's say 'canned
pineapple' it will automatically enter the aisle that it
is in. I can't figure out how to do it. Any ideas or is
there a template?
Thanks!

 

[Mike Painter]

Hi!
I am trying to make a Access 2000 database with my
grocery list. What I want to do is set it up so when I
make a new grocery list and type in, let's say 'canned
pineapple' it will automatically enter the aisle that it
is in. I can't figure out how to do it. Any ideas or is
there a template?
Thanks!

Build a "grocery" table with all the items and the aisle they are on.

Use a "ShoppingList" table with the ID of the grocery item, the quantity and
maybe the date.

Use a query that joins the two for a form and a combobox to select the item.

That way the aisle fills in automatically and you don't have to type
everything.