Form for data entry

[Accessuser67]

Grocery shopping Simple problem 1: I have 3 tables -

Tblcategory - with fields category and aisle
Tblegrocery - with fields grocery id, date, item, category, aisle, qty, amount, total
what I want is a form that I use to enter my grocery receipts and when I get to enter category with a drop down box, the aisle is also shown in the form after I select the category.

your help with this would be greatly appreciated.



regards,
eleanor

[pbaldy]

Does this help?

BaldyWeb - Autofill

[June7]

Sounds like dependent (cascading) comboboxes. Review:
http://datapigtechnologies.com/flash...combobox2.html
https://www.accessforums.net/forms/d...ate-30445.html

Oops, just reread the OP, not dependent comboboxes but this might be helpful
http://datapigtechnologies.com/flash...combobox3.html

[Accessuser67]

Does this help?

BaldyWeb - Autofill

Thanks. Still a little confusing.

regards,
eleanor

[pbaldy]

Well, post back if you have a question about it.

[Accessuser67]

Well, post back if you have a question about it.

Specifically, the two tables are:

tbl category - fields are category and aisle
tblgrocery - date of purchase, item, category, aisle, qty, amount, total, payment memethod

Now I want to use a form to enter the data in the grocery table and have the aisle automatically updated in the form when I select a category.

it is sort of a cheap way to enter my grocery receipts.

Thanks for your assistance.

regards,
eleanor

[June7]

Read Paul's article carefully. It is totally applicable to your situation. Do you REALLY need to save the aisle value in tblGrocery? Why does it matter what aisle the item was in?