My first thread

[casper2079]

Dear all;

I am trying to create an access db to monitor my expenses for my new Snack house.
I have created a "Main" table which will be holding all the daily expenses entries one the fields is called "Type" in which i formatted as combo box with the following values (vegetables , butchery , bakery).
Another field is called "Item" which should list the items based on the Type selection.

Knowing i have a second table in which i stored all types and their corresponding items , how can i force the filed "item" in table Main to simply display the ones i need based on the "Type" input.

I appreciate your help
Thanks in advance

 

[pr2-eugin]

Hello casper2079, Welcome to AWF..

Looking at your description, it seems like you are having this ComboBoxes in table.. Which is a big NO NO in relational databases.. You might want to look over "The Evils of Lookup Fields in Tables"..

What you wish to achieve could be sorted by using Cascading ComboBoxes on Form level.. Search the internet and this forum, you might be able to find some interesting posts.. Good Luck..